Silly Question
 

Hi All

How do I stop users seeing my code?

--

Kind Regards

Mick

Silly Question
 

Mick

in the VBA, protect the Project with a password.

Tools | VBAObject Properties... | Protection tab | Lock project for viewing
| enter a password and confirm.

Regards

Trevor


"Mick Southam" wrote in message
...
Hi All

How do I stop users seeing my code?

--

Kind Regards

Mick

Silly Question
 

Mick,

In the VBA editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "lock
project for viewing" option and enter a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mick Southam" wrote in message
...
Hi All

How do I stop users seeing my code?

--

Kind Regards

Mick

Silly Question
 

Hi Mick,

You can't stop everyone from seeing your code if you use VBA. You can
password-protect your VBA Project (via Tools | VBAProject properties,
Protection tab, check Lock project for viewing and enter a password), but
those passwords can be cracked. If you just want to stop the casual user
from seeing your code, that would suffice. Otherwise, you may want to look
into creating a DLL to encapsulate your sensitive code - then you can call
the DLL functions from VBA.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mick Southam wrote:
Hi All

How do I stop users seeing my code?

Silly Question
 

Thanks everyone

Regards

Mick


"Jake Marx" wrote in message
...
Hi Mick,

You can't stop everyone from seeing your code if you use VBA. You can
password-protect your VBA Project (via Tools | VBAProject properties,
Protection tab, check Lock project for viewing and enter a password), but
those passwords can be cracked. If you just want to stop the casual user
from seeing your code, that would suffice. Otherwise, you may want to
look
into creating a DLL to encapsulate your sensitive code - then you can call
the DLL functions from VBA.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mick Southam wrote:
Hi All

How do I stop users seeing my code?