| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBScript code behind Excel
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run VBScript from Excel | Excel Discussion (Misc queries) | |||
| Trying to Sort and Subtotal with Vbscript in Excel | Excel Programming | |||
| Opening excel spreadsheet from within a VBscript | Excel Programming | |||
| embed excel in ie using vbscript | Excel Programming | |||
| how to kill excel using a vbscript | Excel Programming | |||
Hybrid Mode
