| 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 | |||
Linear Mode
