Thank-you but I am not too worried about people being able to view the
properties of a macro, I am worried about people running the macro.

The steps per your instructions disable anybody from viewing the properties
of a macro which is great but the option to run the macro is still there and
when I tried to run it I was able to run it without having to enter that
password that I used for protecting the properties of it. Is there a way so
that when you click on run that it asks for a password before running it?

"Jens Palacios Neffke" wrote:

1.- Go to the visual basic editor.
2.- To the left theres a list in Bold "VBA Project (name of your workbook),
right click it
3.- Choose VBA Projet properties
4.- Click the Protection Option
5.- Enable "Lock Project from Viewing" and put some password on it

Thats it, next time you enter you wont be able to view your macros without
the password


"Charlene" wrote:

I'm very new to macros and am using Excel 2003. I have written a macro to
protect only certain worksheets within my workbook, however I do not want
everybody being able to run this macro. How do I put security on this macro
so only certain individuals have the ability to execute it?