Passwords

[Nigel Martin]

Is it possible whilst running a macro to un-protect a password protected worksheet without the user being prompted to enter a password, then running whatever macro code has been written, then re-protecting the worksheet with the same password, again without the user being prompted for a password?

 

[Tom Urtis]

The general syntax within your procedure could be something like:

ActiveSheet.Unprotect ("PASSWORD")
'Your code goes here
ActiveSheet.Protect ("PASSWORD")

Of course, modify for actual password characters.

Tom Urtis

 

[Nigel Martin]

Many Thanks Tom, it works well.