View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.