View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
 
Posts: 181
Default how to verify a sheet.visible = true?

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?

"Mike H" wrote:

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

"Alberto Ast" wrote:

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.