Password Protect Macros

[Charles Reid]

Is it possible to password protect your macros, so that no one can mess with
them or update.

Thanks,

 

[Dave Peterson]

Open your workbook
Open the VBE
Select your project
Tools|VBAProject Properties|Protection tab
Give it a memorable password.

Be aware that this protection isn't foolproof. There are password
breakers/avoiders that are available for money or free on the web.

 

[Charles Reid]

hey sir,

thanks for the info, it seems to work, but not exactly what i was looking
for.

how can i get it to where they can not see the macros at all.

 

[Roger Govier]

Hi Charles

Put
Option Private Module
at the top of the module containing your macros, then they will not be
visible from Tools>Macros.

Just Rem the line out when using it yourself.

--
Regards
Roger Govier

hey sir,

thanks for the info, it seems to work, but not exactly what i was looking
for.

how can i get it to where they can not see the macros at all.