Hi,

I'm distributing a workbook with one worksheet which has some VBA
inc.connection to a password protected Access database, using ADO. All the
code is in a Sheet Module.

I can protect the code from viewing by password protecting the project.
However, if the user moves or copies the sheet to another workbook I see
that View Code will open the module for the connection code to be seen!

How can I make my code un-viewable?

Thanks,
Haroon