ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   hidden worksheet? (https://www.excelbanter.com/excel-worksheet-functions/60687-hidden-worksheet.html)

davem

hidden worksheet?
 
How can I set a worksheet to not be hidden. (or can someone tell me where to
find the methods and poperties for working w/ole with an excel file?

Here's the details of the problem. I have an application the uses an
existing excel file as a template. I write to a bunch of cells and then save
under another filename. Each time even though the template worksheet is not
hidden when I save to a new filename it shows up as hidden. I have to pick
unhide to see the worksheet. I have tried setting ....worksheet(1).visible
to true.

Thanks in advance for any help.


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com