How do I prevent certain macros from showing in the macro list box? Please, help!

[Juchelka]

Hello guys, I have another one...

I have several public subs in VB project module. Some of these are
called from various events on the sheets/workbook and subsequently they
show in the macro dialog box list (from user's point of view). Is there
a way to prevent these subs to show in the macro list?

Thank you!

Alex J.

 

[JE McGimpsey]

Hello guys, I have another one...

I have several public subs in VB project module. Some of these are
called from various events on the sheets/workbook and subsequently they
show in the macro dialog box list (from user's point of view). Is there
a way to prevent these subs to show in the macro list?

Add the line

Option Private Module

to the top of the module in which your subs are stored.

Note that a user can still run the macro by typing in the name of the
procedure.

 

[Juchelka]

Wonderful! Thank you JE!

I am protecting the vb project (only for user's own good, of
course...), so guessing the procedure's name would be problably
difficult... This is just a precaution and a shorcut, really, since I
don't know of any cleaner way in Excel...

AJ