Macro to Protect and UnProtect

[mmacw]

i cant turn protection off as first step of macro in order to move some things around, and then turn it back on at the end of the macro. can it be done?

[Carim]

Hi,

Yes, it can be done ...

ActiveSheet.Protect password:="mmacw"

''''' your code

ActiveSheet.Unprotect password:="mmacw"

[Carim]

Hi,

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