I've tried everything but nothing seems to stop the user from being able to
select my chart, nayone know a follproof way of making it impossible to
select a chart on a chartsheet?

Thks, Mark

With Charts("Sales Data")
.ProtectSelection = False
'.ProtectSelection = Not .ProtectSelection to toggle
End With

Regards,
Greg

"Mark Stephens" wrote:

I've tried everything but nothing seems to stop the user from being able to
select my chart, nayone know a follproof way of making it impossible to
select a chart on a chartsheet?

Thks, Mark

This is not my night. Should have been ProtectSelection = True to protect
(obviously). To toggle is the same.

Regards,
Greg

"Greg Wilson" wrote:

With Charts("Sales Data")
.ProtectSelection = False
'.ProtectSelection = Not .ProtectSelection to toggle
End With

Regards,
Greg

"Mark Stephens" wrote:

I've tried everything but nothing seems to stop the user from being able to
select my chart, nayone know a follproof way of making it impossible to
select a chart on a chartsheet?

Thks, Mark

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 ***

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 ***