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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Page numbering with Merged Document and IF statements 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Need some PWA help 0
Cumulative formula for word table 0
Create form with checkbox les that expand and collapse sections of the form? 0
Incone & Expenses Statement 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top