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?

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 wrote:

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

All my macros are in one module, so I don't want to hide the module just
some of the macros in it.
"Dave Peterson" wrote in message
...
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 wrote:

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

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




"jerry chapman" wrote in message
...
All my macros are in one module, so I don't want to hide the
module just
some of the macros in it.
"Dave Peterson" wrote in message
...
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 wrote:

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