Nope. I just remembered incorrectly.

Sub testme(Optional parm As Variant = "")

Doesn't show up in my Tools|macro list, though.


Jim Thomlinson wrote:

MyStuff Shows up in my macro list using the optional parameter. I assume it
does not on your system.
--
HTH...

Jim Thomlinson

"Dave Peterson" wrote:

Just to add to #3:

Sub Mystuff(Optional DummyParm as variant)

and never pass anything.



Jim Thomlinson wrote:

A couple of possible ways around this.

1. Add "option private module" at the top of the module. All of the
procedures in the module will now be hidden from the macro list. Note that
this method hides all procedures in the module from the macro list.

2. Change the procedure declaration to provate. Change
Sub MyStuff()
to
Private Sub MyStuff()
Not that using this method means that the scope of the procedure is changed
and it can not be called from outside of the module.

3. Add an argument to the sub. Change
Sub MyStuff()
to
Sub Mystuff(byval x as long)
Note that using this method requires you to supply a value for x any time
the sub is called.

--
HTH...

Jim Thomlinson

"Shazi" wrote:


Hi Everyone,

I have one question, How to Hide Macros names from the Macro List.

If you press Alt+F78, the macro list window appears, users can run
any macro from this list. how to prevent run any macro from the Macro
List.

Regards.

Shahzad


--

Dave Peterson


--

Dave Peterson