subs with optional args not available to run directly?

[silkworth]

Hi All,

I've noticed that subs with optional arguments are not available run manually via the list of macros (Tools-Macro-Macros...). Is there any other way to get to run them?

Thanks

 

[xenou]

I suppose you have options such as:

keyboard shortcuts
events
worksheet hotspots
command bars
shape objects
userform "Switchboard"
another macro with no arguments to call the macro with arguments

I've used the latter in some cases - subs such as:

Sub CallMySub()
     Call MySub
End Sub

MySub(Optional a as Long)
     ~Code
End Sub

HTH

 

[mikerickson]

They don't appear in the list, but you can type their name into the textbox of the Macros dialog box.