Thread: Correct syntax for hiding a chart sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
  
Posts: 857
Default 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?
Reply With QuoteReply With Quote