Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible
I have an Excel application that copies data from one file into hidden
worksheets in 2 other files. When I updated to Excel 2007, one of the hidden worksheets kept appearing after I ran the data copy procedure and reopened the target file. The only difference between this reappearing worksheet and the other 9 hidden sheets was the fact that the code left the reappearing worksheet active. (I set Excel's screenupdating=false while opening the target files, moving all the data, and then closing/saving the target files.) In 2003, Excel would not change the worksheet's visible property, even though the worksheet had been activated while screenupdating was set to "false". I added one line of code, which set one of the visible worksheets active before saving the file. Once again the hidden sheets remain hidden, all of them. Hope this is informative. THANKS! David G. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble saving xlsm worbook in Excel 2007 | Excel Programming | |||
Excel 2007 xlsm and worksheet links not updatings | Excel Discussion (Misc queries) | |||
If a certain cell has a certain value, a certain worksheet is hidden or visible | Excel Programming | |||
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |