Password Protect Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Reid - 19 Nov 2007 00:41 GMT

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

Thanks,

Reply to this Message

Dave Peterson - 19 Nov 2007 00:55 GMT

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.

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

Signature

Dave Peterson

Reply to this Message

Charles Reid - 19 Nov 2007 05:28 GMT

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.

> Open your workbook
> Open the VBE
[quoted text clipped - 10 lines]
>>
>> Thanks,

Reply to this Message

Roger Govier - 19 Nov 2007 07:46 GMT

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.

Signature

Regards
Roger Govier

> hey sir,
>
[quoted text clipped - 17 lines]
>>>
>>> Thanks,

Reply to this Message