View Single Post
  #3   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

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