Thread: Sub () that does NOT appear in Macro selection
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
J@Y J@Y is offline
external usenet poster
  
Posts: 127
Default Sub () that does NOT appear in Macro selection
I just noticed that Private subs from other modules can't be called. Is there
a way around this?

" wrote:

On Jul 13, 11:46 am, Mike wrote:
Private Sub yourMacroNmae()

"J@Y" wrote:
Is there a way to have a Sub () not appear in the macro selection (alt f9) ?


If a sub has a parameter then it won't appear.

private sub yourMacroName(dummy as object)

Just pass in a 0

Peter


Reply With QuoteReply With Quote