In the VBA IDE, goto ToolsVBA Project PropertiesProtection 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" wrote in message
...
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.