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