macro protection

B

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
 
A

Arvi Laanemets

Hi

I'm not sure about how it affects the access to code through
Tools.Macros.Edit, but you can try to protect the VBA-project - it prevents
(weak protection, of-course) unauthorized access to VBA-modules.

Press Alt+F11, right-cklick onto VBA Project and select
VBA-ProjectProperties.Protection. Set password.
 
D

Dave Peterson

Next time you're in the VBE, protect your project.

Tools|VBAProject Properties|Protection Tab

But don't fool yourself. There's code available that will unprotect that
worksheet in just moments/minutes.

If it's really important to keep protected, then excel may not be the best tool
for you.
 
Top