Worksheet unhide
According to a MSDN article(9328.1019),
"Creating a new instance of Excel and opening a workbook results in an invisible instance of Excel and a hidden instance of the workbook. Therefore, ... your Automation code should unhide the workbook before editing it and saving it. ...". Can anyone tell me how? |
Worksheet unhide
"csdo" wrote in message
... According to a MSDN article(9328.1019), "Creating a new instance of Excel and opening a workbook results in an invisible instance of Excel and a hidden instance of the workbook. Therefore, ... your Automation code should unhide the workbook before editing it and saving it. ...". Can anyone tell me how? Those instructions are very out of date. I don't think that saving a workbook from a hidden instance of Excel has created a hidden workbook since Excel 95. It certainly doesn't in Excel 97 and later, so you really don't need to do anything. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com