One way:

Put

Option Private Module

at the top of each regular code module.


In article ,
Kristanna wrote:

I have written a spreadsheet application that has a lot of macros in it.
However they all appear in the run macro list in the tools menu. I fear that
someone may run an individual macro. Is there any way to make sure the macros
do not show up in that list?