I have a workbook that I have been using for several months now without issue until today. I have a workbook that many users use to view some charts. My data and several (30+)worksheets are very hidden and certain sheets are unhid by password protected macro enabled buttons. I have a button for me that runs a simple for each ws in workbook..... ws.visible = true macro. Today when using this button excel will hang after un-hiding 5 or 6 sheets. The same will happen when I step through the code manually. I have narrowed down where it is happening, but can't locate the problem. Each time the line is processed to set the visible to true, in the locals window, I can see what sheet is being unhid. The "type" column shows the sheet#. When the line that freezes is processed it says worksheet/worksheet but no sheet #, and if I click the + symbol on the ws of the expression column it shows <no variables>. Also in the properties window it shows nothing. I can manually skip that step and it will finish the rest of the sheets without issue. Its like it is trying to unhide a sheet that is not there. Any thoughts or ideas of what to do next.
Bookmarks