Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Hide Sheets

Dim WS As Worksheet
For Each WS In Worksheets
If WS.Name < "Detail" Then
WS.Visible = xlSheetVeryHidden
End If
Next WS

But when I have three Charts in the workbook it is not hidden?!

How I get both charts and sheets Hidden except sheet ("Details")

Thanks

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 Sheets	KrispyData	Excel Discussion (Misc queries)	2	March 25th 09 06:42 PM
Can you hide Sheets?	Abdul	Excel Discussion (Misc queries)	10	November 30th 08 07:09 PM
Hide sheets	Tia[_3_]	Excel Worksheet Functions	3	July 7th 08 08:13 PM
Hide all Sheets	Roba1	Excel Programming	4	June 7th 06 02:41 PM
Hide all sheets but selected sheets - an example	[email protected]	Excel Programming	1	April 7th 06 06:29 PM

All times are GMT +1. The time now is 11:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us