how to verify a sheet.visible = true?

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
A

Alberto Ast

I need to check if a sheet("X").visible is true or false
I mean if the specified sheet is visible I want to make it false but right
now it is failing in my macro because if it is false already it fail.
 
sheets("x").visible = false 'I'd use xlsheethidden

should work.

If the sheet is already hidden, it just won't do anything noticeable.

If the sheet is visible, then it should be hidden.

But there are some cases where you can't hide the sheet.

Is this the only visible sheet in the workbook? Every workbook has to have at
least one visible sheet.

Is this the workbook's structure protected?
(via Tools|protection|Protect workbook in xl2003 menus)
 
Hi,

If sheets("X") is already hidden then making it hidden again won't cause an
error so your problem lies elsewhere.

I'm suspicious of the sheet("X").visible in your question. Because the X is
in quotes it becomes a string and therefore the name of the worksheet, do you
really mean something like this:

For X = 2 To Worksheets.Count
If Sheets(X).Visible Then
Sheets(X).Visible = False
End If
Next

In this case if the sheet is visible it hides it because now X is a variable.

Mike
 
With you input on should be elsewhere I took a deeper look and find out that
I am using a variable to store the sheet name but maybe it is not initiated
yet when I am trying to hide it.... how can I initiate a variable defined as
worksheet so if I want to close it before I use it it will not fail?
 
Back
Top