In Tools = VBA Project properties, select the Protection tab and tick the
Lock Project For Viewing, then enter a password.
Also if your project uses procedures that you do not want your users to see
thru the Macro dialog box, add Option Private Module at the top of your
modules to hide the code from users.

--

Hope that helps,

Phil

------------------------------------------

IT Analyst
SE1, London, UK,

http://uk.geocities.com/philippeoget
philippeoget at yahoo dot com

Programming Excel: <a
href="http://uk.geocities.com/philippeoget/xl/InternetLinkOrganiser.zip"
target="_blank"The Excel A2Z Project: </a
http://uk.geocities.com/philippeoget/a2z/

"jjjjj" wrote in message
...
I am doing some VB Scripting behind an Excel spreadsheet but don't want the
code to be visible when I distribute the spreadsheet. How can I hide it?