Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I hide the code??
Can anyone tell me how to hide VBA code in a excel
applicatiuon so that users can't see it or modify it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I hide the code??
You can place Private before a sub like this
Private Sub test() Or add this at the top of the module Option Private Module This way you don't see it in the macro list (Alt-F8) You can Protect your project in the VBA editor Alt-F11 In the menubar ToolsVBA project properties See the protection tab This way they can't see or edit your code -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "SanMartin" wrote in message ... Can anyone tell me how to hide VBA code in a excel applicatiuon so that users can't see it or modify it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide row code help | Excel Discussion (Misc queries) | |||
Hide Code | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Hide VBA code help | Excel Worksheet Functions | |||
Hide Code | Excel Discussion (Misc queries) |