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

[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.
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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

[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




"jerry chapman" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>