VBA protect and unprotect

[NotSwank]

I have some code that is running behind the scenes when an intersection change has been made. I want to protect this sheet as other people will be using it. I need to add to my existing code, something to unprotect every time the script runs and reprotect it once it is done. I'm unsure all the points I need to add it into.

Here is my code thus far, I apologize it is rather lengthy:

Please Login or Register  to view this content.

That is the first half.

[NotSwank]

second half:

Please Login or Register  to view this content.

[NotSwank]

Final piece:

Please Login or Register  to view this content.

[Winon]

Hello NotSwank,

For each of your procedures within your Code, with every action to be executed, and at the beginning of that instruction, you should use the Sheet #, or the Sheet Name,i.e.

Sheet1.Unprotect "password" or

Sheets("Whatever").Unprotect "password"

and then, and at the end of any such instruction you would end with;

Sheet1.Protect "password" or

Sheets("Whatever").Protect "password".

Regards