Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to Add data to exsiting worksheet jonesaa05 Excel Discussion (Misc queries) 7 October 14th 05 01:20 PM
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
Accessign formula's in worksheet that appear to have been hidden Tim Ashcom Excel Discussion (Misc queries) 9 July 22nd 05 04:53 PM
Worksheet Function - Find? DAA Excel Worksheet Functions 2 February 24th 05 04:15 PM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"