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

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