Show or Hide a worksheet with a macro

H

Hasty

I'm trying to hide some specific worksheets in my workbook and in the same
time to show other worksheets, depending of the choise i make. Can anyone
help me please
 
S

Stefi

hide: Worksheets("worksheetname").Visible = False
unhide: Worksheets("worksheetname").Visible = True

Regards,
Stefi

„Hasty†ezt írta:
 
S

Stefi

Only one by one, e.g. see Help on Visible Property:

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


Stefi

„Hasty†ezt írta:
 
H

Hasty

Thank You! That answered my puzzle

Stefi said:
Only one by one, e.g. see Help on Visible Property:

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


Stefi

„Hasty†ezt írta:
Click to expand...
 
Top