What is the correct syntax in a macro 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?

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?

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 <BBDFE6CE-6ECC-4273-951E-(E-Mail Removed)>,
Brad <(E-Mail Removed)> 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
> >