Hey all! It's a wonderful day in the neighborhood I see
Here's another head-scratcher for you. I have a main form defined and a function that is called from there via a button control takes about 40-60 seconds to run. So, in keeping with the basic GUI rules, I change the mousepointer to the hourglass and set the userform.enabled=false property so the can't accidentally (or intentionally) move or close the form.
First step, as usual, is to step through the new code and all seemed to work well. Then, I ran it normally and when the mousepointer changes back, everything should be done. The only problem was that I couldn't click on any of the controls nor could I close the form with the closebox (upper right).
Hmmmmmmm I said to myself. Back to single step mode and all works fine. After the sub finishes, I can click on any control and/or close the form. I did that 5-6 times in a row without actually closing it and then just told it to run and I couldn't close it again. I even tried adding in a "sleep 100" before and after the userform.enabled=true.
Since my head already hurts, I thought I'd share the joy with you guys and see if anyone has any ideas.