Protecting a Macro

[Paul Blarmy]

I have devised a spreadsheet with macros that open external data files
and manipulate the date. I am able to protect the worksheet but others
are able to edit the macros even though the worksheet itself is
protected.

Is there a way to protect the macro from being edited? I still want users
to be able to run the macro, just not edit it.

Using Excel 2000 (ver 9?) on a Windows 98SE machine.

TIA

 

[Gord Dibben]

Paul

ALT + F11 to open VB Editor. CRTL + R to open Project Explorer.

Right-click on your workbook/project and "Properties".

On Protection Tab "lock project for viewing" and enter a password. Save/close
and re-open your workbook for protection to take effect.

DO NOT FORGET the password.

Gord Dibben Excel MVP

 

[Paul Blarmy]

ALT + F11 to open VB Editor. CRTL + R to open Project Explorer.
Right-click on your workbook/project and "Properties".
On Protection Tab "lock project for viewing" and enter a password. Save/close
and re-open your workbook for protection to take effect.

Thank you very much Gord, that has done what I wanted.

Is this documented anywhere in the help files, did I just not look in the
right place?

 

[Gord Dibben]

Paul

It shows up if you enter "project properties" in the answer Wizard.

Otherwise very hard to find.

Gord

 

[Dave Peterson]

I use xl2002 and inside the VBE, I typed in "project protection" into the "ask a
Question" box.

The fourth item returned was: "Set Project Properties"

And after I clicked that:

Use the Protection tab in the <projectname> Properties dialog box to lock the
project from viewing by others and specify a password for access to project
properties. After you set protection, you must save and close your project for
the protection to take effect.

 

[Paul Blarmy]

On Wed, 10 Mar 2004 17:15:21 -0600, Dave Peterson wrote...

Use the Protection tab in the <projectname> Properties dialog box to lock the
project from viewing by others and specify a password for access to project
properties. After you set protection, you must save and close your project for
the protection to take effect.

Thanks Dave.

 

[Paul Blarmy]

It shows up if you enter "project properties" in the answer Wizard.

Otherwise very hard to find.

You're not joking!

Thank you again Gord.