Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to verify a sheet.visible = true?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to verify a sheet.visible = true?
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) 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to verify a sheet.visible = true?
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |