Hidden Sheets and Formulas

M

micheldevon

Is it possible to create an If then statement that is determined by
whether or not another worksheet is hidden.

i.e. if(WorksheetA is hidden, "X", "Y")

something like that, or is this completely dumb?
 
F

flummi

This example hides Sheet1.

Worksheets("Sheet1").Visible = False
This example makes Sheet1 visible.

Worksheets("Sheet1").Visible = True

You can also use this in an if statement

Hans
 
Top