Posted to microsoft.public.excel.programming

Bob Phillips[_5_] Bob Phillips[_5_] is offline

external usenet poster

Posts: 620

Hide Sheet

activesheet.visible=xlveryhidden

to unhide

worksheets("Sheet1").visible=true

--

HTH

Bob Phillips

"AA2e72e" wrote in message
...
How can a sheet be hidden such that it cannot be unhidden
via Format | Sheet | Unhide?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Create Sheet, Hide Sheet	Dave	Excel Discussion (Misc queries)	2	October 30th 07 03:40 PM
hide sheet name/ Tab	Anand vijay	New Users to Excel	7	January 7th 07 12:30 AM
How do I hide a sheet, that others will not be able to see it?	Petya	Excel Worksheet Functions	6	January 5th 07 08:46 AM
hide sheet	hitesh via OfficeKB.com	Excel Discussion (Misc queries)	3	October 20th 06 02:51 PM
Hide a sheet	gavin	Excel Discussion (Misc queries)	1	September 14th 05 06:40 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us