I removed "Application.ScreenUpdating = False" from the code and it
works fine now. The code was located on the sheet with the toggle
button and combo box. I'm not sure why it had an effect on the other
sheets.
THANKS FOR ALL YOUR HELP!!!
JE McGimpsey wrote in message ...
There's nothing inherent in the code itself that would cause XL to 'lock
up'.
Where is this code located? Can you set breakpoint(s) and step through
the code to see where the 'lockup' occurs?
In article ,
(Stephen) wrote:
I tried the script below and it works. However, now when I try to
insert cells, Excel locks up. When I right click and select close on
the program, it asks if I want to save my changes. I've tried it on
different computers with the same result.