Silly Question

T

Trevor Shuttleworth

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
 
C

Chip Pearson

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
 
J

Jake Marx

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]
 
M

Mick Southam

Thanks everyone

Regards

Mick


Jake Marx said:
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 said:
Hi All

How do I stop users seeing my code?
Click to expand...
Click to expand...
 
Top