View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hande & Tolga Hande & Tolga is offline
external usenet poster
 
Posts: 2
Default All Sheets Unhide and Select

Question 1:
We are missing the visual basic code for selecting all
sheets in the workbook without having specific names for
all the sheets.

Question 2:
We want to unhide all hidden sheets in the workbook
without specifying specific names of them with one line
of code. We have achieved this with for next already but
not with a specific code line.

For Each sh In Sheets
sh.Visible = True
Next sh