What combination of statements do I want to use...

[Glory]

What combination of statements do I want to use to indicate that I want to be able to see the "Sub" procedure I'm creating in the Macro menu (the one revealed with alt+F8) when the project that contains the module is active, but not when it's not?

I tried Option Private Module but that just makes the subs vanish completely, even when they're explicitly declared as public subs wt the procedure level.

 

[Glory]

Yeah, it even disables accelerators when you use "Option Private Module". I just want to not be drowned in loads of extraneous subs. Can I do that with a VBA module-level declaration statement, or is there some setting I can tweak somewhere that will work for me?

 

[Glory]

bump

 

[ScottR]

In a normal module, just declare a Private Sub.

It has implications if you want to call that Sub outside of the module but in that case you can do something like

Application.Run "MyPrivateSub"

Wouldn't really recommend doing this though.

 

[Glory]

What wouldn't you recommend doing? Making the module private?

Making the module private doesn't allow me to see the macro in the F8 macro menu when the project is the active window. That's what I'm looking for.