Password Problem

I was provided with the code below, which work exactly how i want it to and a big thanks to the forum member that took therir time in writing it for me.

But when i run this marco, i get a Password msgs box appear, now is there away of running it so that it does not ask for a password, I have tried to unprotect the sheet with a password which works, but it never re-protected it self,

I don't know that much about VBA and my programming knowledge is very limited. I dont want the code re-written, as its someone elses work and it does what i want, i just need to know if an extra line can be entered to stop the password msg box. I.E. it needs to run without asking for the password

Please Login or Register  to view this content.

Did you make the change suggested for this problem in the previous thread? Here it is again...insert the password into the line like so:

Please Login or Register  to view this content.

...and of course adjust it to use your actual password.

You could do it this way#

Please Login or Register  to view this content.

Or apply protection with userinterface, which would allow macros to run on protected sheets, see example

http://www.excel-it.com/vba_examples.htm