Password Protect Macros

  • Thread starter Thread starter Charles Reid
  • Start date Start date
C

Charles Reid

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

Thanks,
 
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.
 
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.
 
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



Charles Reid said:
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.
Click to expand...
 
Back
Top