I don't want just any old user to have access to macros. How can I prevent
user access to macros. I can't share the workbook because I have seen
problems with that.

Mike,

There is no secure way of protecting code in a workbook.

Mike

"Mike H." wrote:

> I don't want just any old user to have access to macros. How can I prevent
> user access to macros. I can't share the workbook because I have seen
> problems with that.

Depends on your definition of secure really. If its just to stop
average Joe Bloggs at work from getting access to your code, open up
the code editor, select tools - vba project properties - protection
tab, and lock the project for viewing and set the password.

In the VBA IDE, goto Tools>VBA Project Properties>Protection and check the
"Lock project for viewing, and optional enter a password.

Also, depending on you intentions, look into "Option Private Module" and
possibly use an Add-In.

NickHK

"Mike H" <(E-Mail Removed)> wrote in message
news:A2B75EE7-8E67-4747-92CB-(E-Mail Removed)...
> Mike,
>
> There is no secure way of protecting code in a workbook.
>
> Mike
>
> "Mike H." wrote:
>
> > I don't want just any old user to have access to macros. How can I
prevent
> > user access to macros. I can't share the workbook because I have seen
> > problems with that.

My definition of secure is to prevent average Joe Bloggs at work from getting
into the code and messing it up. This is exactly what I want! Thanks...