Making changes to a hidden worksheet
Posted by Stan on December 01, 2001 12:53 PM
Earlier I posted a message about an application execution error I was getting when closing an Excel VBA file. Here's what I've since learned:
The file has all but one worksheet hidden. If I make change programatically to a hidden worksheet (i.e. change the value of a cell), I get an error when exiting the file. But if the sheet is not hidden when I make the change, there is no problem. Any idea what's happening?