Hide the Macro form Dialog Box

[RA199]

Good Evening

I am new in VBA in excell , I was practicing & there are many macro .My question is if there is any way to hide a macro from appearing as an option in the dialog box .


Thanks

[Logit]

When naming the SUB put PRIVATE in front of the term SUB ....


Private Sub ThisIsMySubName ()
... your code.....
End Sub

[Paul_Hossler]

Also, if you know the macro name, you can still manually enter the name and then run it

Also #2, if the Sub requires parameters it won't show in the list

[Dave]

You can also change your Sub to a Function which will make you crazy when you're looking on you're macro list for a procedure that obviously exists (personal experience). Dave

[Aflatoon]

Or use Option Private Module