hide macro in listbox
 

Is there a way to hide or prevent some of my sub procedures from showing up
in the macro list box? some of the procedures are called by other macros and
are never started directly by the user, so they only clutter of the listbox
when someone chooses tools, macros,macros.

hide macro in listbox
 

Hi BillyRogers

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)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"BillyRogers" wrote in message ...
Is there a way to hide or prevent some of my sub procedures from showing up
in the macro list box? some of the procedures are called by other macros and
are never started directly by the user, so they only clutter of the listbox
when someone chooses tools, macros,macros.

hide macro in listbox
 

Your the BEST Ron!!!!!!!!!!!

"Ron de Bruin" wrote:

Hi BillyRogers

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)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"BillyRogers" wrote in message ...
Is there a way to hide or prevent some of my sub procedures from showing up
in the macro list box? some of the procedures are called by other macros and
are never started directly by the user, so they only clutter of the listbox
when someone chooses tools, macros,macros.