Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visible = True - Not Working | Excel Programming | |||
For...Loop to verify at least one checkbox = True | Excel Programming | |||
Set Visible Cells To TRUE | Excel Programming | |||
TextBox.Visible = True ... not working | Excel Programming | |||
ActiveWindow.Visible = True | Excel Programming |