Thread: Macro Recorder didn't record my password

I started the macro recorder, selected Sheet1, Protect, Password then Sheet 2 and repeated. Read the script and no mention of the code for password on and password text!

Good morning beegeeblueboy

Originally Posted by beegeeblueboy

I started the macro recorder, selected Sheet1, Protect, Password then Sheet 2 and repeated. Read the script and no mention of the code for password on and password text!

..and therre's very good reason for that - think about it.

Use this to protect and unprotect with a password :

ActiveSheet.Protect Password:="mypass"
ActiveSheet.Unprotect Password:="mypass"

HTH

DominicB

Originally Posted by dominicb

Good morning beegeeblueboy

..and therre's very good reason for that - think about it.

Use this to protect and unprotect with a password :

ActiveSheet.Protect Password:="mypass"
ActiveSheet.Unprotect Password:="mypass"

HTH

DominicB

Thanks for the code Dominic.

Whilst I appreciate what you say protecting the project would stop someone reading the script.

Hi beegeeblueboy

Originally Posted by beegeeblueboy

Whilst I appreciate what you say protecting the project would stop someone reading the script.

Only if you protect the code, but even if you did, TBH it's not that difficult to get into a locked VBA project. If we're going down that route, it's even easier to remove sheet protection.

Excel security is lousy. If secrecy / locking things down is of paramount importance, don't use Excel.

DominicB