I used to be able to lock the VBA code for viewing with a password in
Excel 2000. I closed down all the Worksheets, Forms, and Modules in
the VBeditor. Then, I went to Tools VBAProject Properties and
select the Protection tab, clicked "Lock project for viewing", and
entered a password. It seemed to work fine. Whenever I attempted to
view the any of forms and/or, I was challenged with a password.

But when I try to do the same thing in Excel 2003, there's something
wrong. After I've been simply using the app (not in the VB Editor)
and then close Excel, I get the password challenge prompt. That
clearly is not acceptable if I want other people to just use the app.
Can someone tell what I'm doing wrong?

Thanks in advance.

The only thing that comes to mind is that when first protecting a project, I
believe that xl must be closed, then reopened before the protection goes into
effect.

I assume you have done this but maybe not.

"bobkaku" wrote:

I used to be able to lock the VBA code for viewing with a password in
Excel 2000. I closed down all the Worksheets, Forms, and Modules in
the VBeditor. Then, I went to Tools VBAProject Properties and
select the Protection tab, clicked "Lock project for viewing", and
entered a password. It seemed to work fine. Whenever I attempted to
view the any of forms and/or, I was challenged with a password.

But when I try to do the same thing in Excel 2003, there's something
wrong. After I've been simply using the app (not in the VB Editor)
and then close Excel, I get the password challenge prompt. That
clearly is not acceptable if I want other people to just use the app.
Can someone tell what I'm doing wrong?

Thanks in advance.