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?