How to protect user from viewing VBA codes in Excel 97?

Posted by Darren Lam on June 30, 2000 4:35 AM

Hi guys.....need help here

I got a problem on preventing users from viewing my VBA codes and userforms. The only way i can think of is disabling Visual Basic Editor function from MS-Excel, but i don't know the way.

I would appreciate your ideas and suggestions to help me get rid of this security problem.

Regards,
Darren

Posted by JAF on June 30, 0100 4:40 AM

Darren

In the Visual Basic Editor, select VBAProjectProperties from the Tools menu. Select the Protection tab, tick the Lock project for viewing box, enter and confirm your password (Case Sensitive).

Exit the VBE, save and close the workbook. When the workbook is re-opened, any code wil be protected.

JAF

Posted by Darren on July 04, 0100 7:56 PM

JAF,

Thanks for your advise .... Appreciate it a lot.
Have a nice day. Thanks again.

Regards,
Darren