For your first question, use
Worksheets.Select

For your second question, you need to use the For Next loop. There isn't a
single line of code for unhiding all worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Hande & Tolga" wrote in message
...
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