Thread: Protect sheets from editing but allowing macro to do so?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
  
Posts: 119
Default Protect sheets from editing but allowing macro to do so?
To protect al sheets in the Workbook

For each Sh in Worksheets.Count
Sh.Protect UserInterFaceOnly:=True
Next

Regards, Don

"NooK " wrote in message
...
Is it possible to protect all the sheets from a workbook from edition
allowing the macros to edit the cells and so on?

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote