VBScript code behind Excel

[Guest]

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?

 

[Tom Ogilvy]

In the VBE with your workbook with the code the active project, go to
Tools=> "vbaproject name" properties

where vbaproject name would be replaced with the name of your project (which
is shown in the project explorer as part of the root name of your project
and this name should be something other than vbaproject - the default).

Anyway, this has the options for password protecting your project.

 

[Philo Hippo]

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/