View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank[_19_] Frank[_19_] is offline
external usenet poster
 
Posts: 8
Default 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