Posted to microsoft.public.excel.programming

Frank[_19_] Frank[_19_] is offline

external usenet poster

Posts: 8

Hiding and Unhiding work sheets

I know by using the following code I can un-hide all work
sheets,

Sub sheetunhide()
For Each sh In Sheets
sh.Visible = True
Next sh
End Sub

I also want to be able to hide all sheets except a
specific one, does anyone know how to do this.

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
toolbar "button" for hiding/unhiding sheets	Barb in MD	Excel Worksheet Functions	2	February 10th 10 01:45 AM
Hiding / Unhiding Sheets	Larry Fitch	Excel Discussion (Misc queries)	1	December 2nd 09 02:42 PM
need code for hiding/unhiding sheets using checkboxes	pzx8hf	Excel Worksheet Functions	1	August 13th 08 12:11 AM
Hiding and unhiding sheets	D.Hay	Excel Discussion (Misc queries)	2	December 10th 05 03:59 PM
Hiding/Unhiding	Bobby	Excel Worksheet Functions	2	May 25th 05 10:40 PM

All times are GMT +1. The time now is 08:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us