View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davem
 
Posts: n/a
Default 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.