Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding Macros
Thanks for the insight Ron. Your answer was very helpful to me.
Regards Paul Curran "Ron de Bruin" wrote: Hi 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) and 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 http://www.rondebruin.nl "Broadband Al" wrote in message ... Is it possible to hide macros so that they are not listed in the Tools-Macros dialog? -- Oxfordshire, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |