Hi Folks,
This is very frustrating and I hope someone might have the answer.
I have a worksheet_change procedure that is triggered when certain cells in my input sheet are changed. The procedure is supposed to go into another sheet and hide some columns. Its doesn't. The procedure is certainly triggered, it just seems to skip over the lines of code that do the looping and hiding. I fear it might be something to do with loosing focus?
Also, I can't seem to actually step through the procedure. It's like this procedure is somehow exempt from the usual debugging functionality of the VBA Editor.
Any ideas?
Here's the code:
Bookmarks