Hi Nook,

Try:

Dim sh As Worksheet
For Each sh In ActiveWorkbook.Sheets
ActiveSheet.Protect password:="PW", _
UserInterfaceOnly:=True
Next


Replace PW with your designated password


---
Regards,
Norman



"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/