Hidding macros

[jerry chapman]

I have an Excel program with several macros. When I click on
Tools->macros->macros I see all my macros listed, but some of them are only
subroutines used by other macros. How can I keep certain macros from beeing
listed when I list the macros?

 

[Dave Peterson]

One way is to add:

Option Private Module

to the top of each of the modules (not each procedure--just at the top of each
module).

 

[jerry chapman]

All my macros are in one module, so I don't want to hide the module just
some of the macros in it.

 

[Chip Pearson]

Declare the procedure as Private. E.g.,

Private Sub AAA()
MsgBox "OK"
End Sub

Note that the procedure can still be executed from the Macro
dialog if you know the name. It just won't appear in the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

All my macros are in one module, so I don't want to hide the
module just
some of the macros in it.