December 17, 2007 at 11:46 PM #1 To hide a worksheet upon open I use: Code wsSheet.Visible = xlSheetVeryHidden What do I use to hide a chart which is its own worksheet?Thanks,Guy
December 18, 2007 at 12:08 AM #2 Re: Hide Chart Upon OpenSimply use the sheet name.If the chart is embedded on sheet1 then use Code sheet1.Visible = xlSheetVeryHidden If the chart is on a chart sheet, say Chart1, then Code Chart1.Visible = xlSheetVeryHidden
December 18, 2007 at 12:42 AM #3 Re: Hide Chart Upon Open Quote from AAE Simply use the sheet name.If the chart is embedded on sheet1 then use Code sheet1.Visible = xlSheetVeryHidden If the chart is on a chart sheet, say Chart1, then Code Chart1.Visible = xlSheetVeryHidden Sheeesh, sorry, that was too easy. Thanks for your help.Guy
December 18, 2007 at 12:54 AM #4 Re: Hide ChartYou're welcome. Can't tell you how many time I couldn't "see the forest for the trees."