Protecting VBA macro from modification by users

[Guest]

I want to prevent users from modifying a VBA macro in Excel. Otherwise, the
sheet should be unprotected. How can I do this? Thanks.

Mike

 

[Tom Ogilvy]

In the vbe, in tools=>vbaProject Properties

there is an option to protect your code.

You should rename your project first (not the workbook name) to something
unique. The default name is vbaProject. Once you do that it will be
tools => YouNewProjectName properties.

You then have to save the workbook and close it. When you reopen it, the
protectin will be applied.

 

[Guest]

You need to get into the VBE (Alt F11) IN the left hansd side you will see a
list of all of the projects currently open. Right Click on the project
(spreadsheet) you want to protect. Select Properties and then select the
protection Tab... Add a Password and Bob's your uncle. One thing to note is
that a protected project will not allow you to enter the debug mode if the
VBA crashes, so you will have to Unprotect it a recreate the error to debug
it...

HTH