Thread: Protected cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Protected cells

ActiveSheet.EnableSelection = xlUnlockedCells

this must be set each time the workbook is opened as it is not persistent.
Possibly use the workbook_open event or put it in the sheet activate event.

--
Regards,
Tom Ogilvy

wrote in message
...
Hello,

How do I my protected cells in a sheet unselectable?
Thanks in advance