Just wanted you all to know that I used the instructions below and it works
great! Just what I was looking for!

Thanks loads!

"Ron de Bruin" wrote:

Hi Sharon

Press Alt F8 and enter the macro name

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SharonP." wrote in message ...
Dave, I'm working with this hint and am having a problem/question.
When I add this Option Private Module as a Declaration - is is not visible
in the Tool/Macro/Macros but I also can't run the macro either. What am I
missing. I don't want the macro viewable for the general public but I need
to run it still.

"Dave Peterson" wrote:

If you add:
Option Private Module
to the top of each general module, then the names won't be visible in the
Tools|macro|macros... dialog.

wrote:

Thanks Julie. I had done that, but the user can still run a macro by
selecting Tools/Macro, selecting a macro, and clicking Run.

Also, I realize that worksheet and workbook protection are easily
bypassed. I just need to keep the user from stupidly running a macro
that can screw up the book.

On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
wrote:

Hi

you can password protect the vba project (ie the macros), press ALT & F11 to
switch to the VBE editor,
find your workbook's name in the Project Explorer (view / project explorer)
right mouse click on it
choose VBAProject Properties
Go to the protection tab
tick the check box and put a password in.

--

Dave Peterson