Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct syntax for hiding a chart sheet
What is the correct syntax in a macro for hiding a chart sheet?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct syntax for hiding a chart sheet
Brad,
One way: to hide a chart sheet named Chart1 Sheets("Chart1").visible=xlSheetHidden -- Hope that helps. Vergel Adriano "Brad" wrote: What is the correct syntax in a macro for hiding a chart sheet? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct syntax for hiding a chart sheet
Sheets("chart5").Visible = False
gives me a subscript out of range runtime error 9 "Vergel Adriano" wrote: Brad, One way: to hide a chart sheet named Chart1 Sheets("Chart1").visible=xlSheetHidden -- Hope that helps. Vergel Adriano "Brad" wrote: What is the correct syntax in a macro for hiding a chart sheet? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct syntax for hiding a chart sheet
Check your chart sheet title - are there any additional spaces (e.g.,
"Chart 5", "Chart 5 ")? You could (and in most cases, *should*) use the CodeName: Chart1.Visible = xlSheetHidden In article , Brad wrote: Sheets("chart5").Visible = False gives me a subscript out of range runtime error 9 "Vergel Adriano" wrote: Brad, One way: to hide a chart sheet named Chart1 Sheets("Chart1").visible=xlSheetHidden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correct Syntax | Excel Discussion (Misc queries) | |||
CORRECT SYNTAX FOR RUN... | Excel Programming | |||
Correct Syntax | Excel Programming | |||
If...and... - can never get the syntax correct! | Excel Programming | |||
Can't get this syntax correct, please help. | Excel Programming |