I have several Excel spreadsheets that have code sitting behind them. In some of these spreadsheets, user forms are shown to prompt user's for info that the spreadsheets need. The problem I'm experiencing is that, on rare occasions, when the .show line is executed, not only does the form appear, but the vb editor pops up with the .show line highlighted in yellow (as if I were debugging).
I'm hoping someone might know what causes this to happen. As I stated, it doesn't happen very often (3 or 4 times in the last 6 months) and, when it does, a quick reboot takes care of the problem. I'm just hoping someone can give me some idea to stop it completely. Any help would be greatly appreciated. Thanks all!!
I'm hoping someone might know what causes this to happen. As I stated, it doesn't happen very often (3 or 4 times in the last 6 months) and, when it does, a quick reboot takes care of the problem. I'm just hoping someone can give me some idea to stop it completely. Any help would be greatly appreciated. Thanks all!!
