Macro's and password protected sheets

[02rj03]

Hi there

Is there anyway possible when recording or writing a macro to be able to unlock a password protected sheet then relock and repassword (very important) the same sheet once i have finished with the sheet?

I have tried to make a macro to password protect the sheets. Whilst it protected the sheet it wouldn't put the password in.

Thank you in advance

 

[VoG]

To protect

ActiveSheet.Protect Password:="abc"

to unprotect

ActiveSheet.UnProtect Password:="abc"

 

[cytop]

Recorded macros do not record passwords - it's a security measure. You'll have to edit the macro manually.

You might also like to look up the UserInterfaceOnly parameter of the Protect method..

 

[Simon B]

I would then recommend password protecting the VBA modules, otherwise someone can just go in and look at the code to see the password.

 

[VoG]

I would then recommend password protecting the VBA modules, otherwise someone can just go in and look at the code to see the password.

Even that isn't particularly secure, unfortunately.

 

[02rj03]

I would then recommend password protecting the VBA modules, otherwise someone can just go in and look at the code to see the password.

How do i go about doing this?

 

[VoG]

In the Visual Basic Editor, Tools > Project Properties, Protection tab, tick Lock Project for Viewing, enter a password and click OK. Save, close and re-open the workbook to see the effect.

 

[02rj03]

In the Visual Basic Editor, Tools > Project Properties, Protection tab, tick Lock Project for Viewing, enter a password and click OK. Save, close and re-open the workbook to see the effect.

Thankyou very much for your help