Protecting macros to avoid unauthorised changes

[Des]

Hi

I heard of a method using the VBA editor to protect
macros with a password to avoid changes to the macros.

Can someone help me with the detail of this procedure.

Thanks

Des.

 

[Don Guillett]

in the vbe>right click on the workbook name>properties>protection

 

[Harald Staff]

Hi Des

In the VB editor: Tools > VBA Project properties > Protection.

Note that after you've done this, protection doesn't kick in until you save, close and
reopen the file, assuming that you are the rightful owner the rest of the current session.
So don't panic when you still can see your code.

 

[J.E. McGimpsey]

In the VBE, Tools/(project) Properties/Protection tab. Check the
Lock project for viewing checkbox and enter a password.

Note: you'll still see the project as available until you close and
reopen the file.