Posted to microsoft.public.excel.programming

Jeremy Gollehon[_2_] Jeremy Gollehon[_2_] is offline

external usenet poster

Posts: 35

Hide/Unhide worksheets help

Using OfficeXP.
In a fresh workbook from the immediate window...

This works.
Worksheets(Array("Sheet1", "Sheet2")).Visible = xlSheetHidden

This:
Worksheets(Array("Sheet1", "Sheet2")).Visible = xlSheetVisible

gives the following error

Run-time error '1004':
Unable to set the Visible property of the Sheets class

This seems like an easy one, but I haven't been able to find an answer.

Thanks,
-Jeremy

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
Hide/Unhide worksheets upon entries in a range of the main worksheet	ran58	Excel Discussion (Misc queries)	5	July 22nd 09 07:31 AM
Hide/Unhide row VBA	Scafidel[_2_]	Excel Discussion (Misc queries)	1	March 23rd 09 05:28 PM
How do I hide and unhide worksheets in Excel 2007?	Wayne from Ottawa Canada	Excel Discussion (Misc queries)	0	August 14th 06 02:54 AM
Hide Unhide	Colin	Excel Discussion (Misc queries)	4	April 9th 06 05:01 PM
Hide/unhide	Jock W	Excel Worksheet Functions	4	October 4th 05 05:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us