hide macro in listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Your the BEST Ron!!!!!!!!!!!

Ron de Bruin said:
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)
Click to expand...
 
Back
Top