View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default Can't protect chartsheets in my workbook

Just use the name of the chart sheet as listed in the sheet tab. For the code
example, I used "Sales Data". As no doubt you are already aware, you can
change chart sheet names the same way you can worksheet names, by
right-clicking the tab and selecting the Rename option.

Regards,
Greg


"Mark Stephens" wrote:


Hi Greg,

Thanks for that but does it work for a chart sheet as well as a chart
embedded in a workbook? If so how do you find the name of the chart in
your chartsheet?

Thanks for your help, Mark


*** Sent via Developersdex http://www.developersdex.com ***