Hi,
I have developed an application using Excel VBA. I have also protecte
the worksheets. But, if I already keep VB open and then open th
protected worksheet, I am able to view the code.

I want this code to be protected and should not be viewed by other
after distributing the application.

I have seen similar applications where even for veiwing the VB code, i
asks for the password. Can anyone tell me how can this be mad
possible.


Thanks,

Samee

--
Message posted from http://www.ExcelForum.com

On Wed, 19 May 2004 08:27:30 -0500, wrote:

Hi,

In XL2000:

In VBE, Tools-VBAProject Properties, click protection tab

-TJ

I have developed an application using Excel VBA. I have also protected
the worksheets. But, if I already keep VB open and then open the
protected worksheet, I am able to view the code.

I want this code to be protected and should not be viewed by others
after distributing the application.

I have seen similar applications where even for veiwing the VB code, it
asks for the password. Can anyone tell me how can this be made
possible.


Thanks,

Sameer


---
Message posted from http://www.ExcelForum.com/