Silly Question

  • Thread starter Thread starter Mick Southam
  • Start date Start date
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,

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
 
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]
 
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...
 
Back
Top