Thank you, Tom. You are right - once I closed and re-opened workbook, got in
vba design mode, and double-left-click on command button, I needed to enter
the project pwd to see the code. I had been testing security before
close/open of workbook - that was my only problem. Thanks again ...

bill

"Tom Hutchins" wrote:

Since you have password protected the VBA project, the user will not be able
to view any of the VBA code in the workbook (including sheet modules) without
either suplying the password or removing it. If you right-click on the tab of
the sheet with the command button and select 'View code', you should be
presented with a password entry dialog. Likewise, if you go into design mode,
right-click on the command button and select view code. When you
password-protect the VBA project, you have to save, close, and re-open the
workbook to test it.

Hope this helps,

Hutch

"WCM" wrote:

Hi Friends,

In my Excel Project, I have hidden all VBA code modules by inserting 'Option
Private Module' in the General Declarations section; I have also password
protected the VBA project.

Question:
I have a command button on one worksheet - the button has VBA code behind it
(simple code that calls a sub proc from a code module).

I would like to hide the code behind the button, but there seems to be no
way to hide code that is in an Object Module (as opposed to a standard Code
Module).

Any way to hide code that is behind a command button so user cannot go into
VB design mode and see that code behind the button? Note: Assume that
protecting the worksheet is not an option.

Thanks in advance ...

Bill