Macro to Protect and UnProtect

Hi,

Yes, it can be done ...

ActiveSheet.Protect password:="mmacw"

''''' your code

ActiveSheet.Unprotect password:="mmacw"

Hi,

In order to protect your code ...
Alt F11
In the project window (left)
Highlight VBAProject(YourWorkbookName)
Right Click
Select VBAProject Properties
Protection ...