C Charles Reid Nov 19, 2007 #1 Is it possible to password protect your macros, so that no one can mess with them or update. Thanks,
D Dave Peterson Nov 19, 2007 #2 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.
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.
C Charles Reid Nov 19, 2007 #3 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.
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.
R Roger Govier Nov 19, 2007 #4 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...
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...
