macro protection

[Byers]

In my macro that I wrote, I have the password to unprotect th
worksheet. I would like to keep that a secret. The button a create
for my macro is protected, so it cannot be change, but the user of m
workbook can go into tools>macros> and edit the macro there.
Is there a way to make it so they cannot view the macro code?
Data still needs to be entered in places on the worksheet, but I'v
designed it so that it can only be entered in specified places

 

[Andrew]

Hi there,

Right click the module, select VBAProject Properties, then the
Protection tab. You'll see a place to enter your password there.

Hope this helps.

 

[Frank Kabel]

Hi
in the VBA editor select your project and right-click on
it to topen the VBAProperties dialog. In the protection
tab enter a password.

note: This kind of protection is easily circumvented (less
than 1 minute to do)

 

[Byers]

I'm not looking for protection against hackers, just regular compute
users so they can't mess it up. However, my curiosity would like t
know how it can be "circumvented."


thank yo

 

[Andrew]

Click the User CP button at the top and you will see a link to edi
your profile

 

[Frank Kabel]

Hi
in this case this kind of protection is probably
sufficient.

For removing passwords see:
http://www.mcgimpsey.com/excel/removepwords.html