Worksheet unhide

  • Thread starter Thread starter csdo
  • Start date Start date
C

csdo

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?
 
csdo said:
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?
Click to expand...

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 *
 
Back
Top