Exactly. Plus if the project uses a lot of classes, trying to run almost any
procedure without having run the initialization routines first generally
won't accomplish (or damage) anything, since the necessary objects weren't
created or collections are empty. Very little could be done in a cold-start
vacuum.

However, there are a few exceptions and they may be worth some thought.

Maybe. When I have some spare time. :-)

--
George Nicholson

Remove 'Junk' from return address.


"Dave Peterson" wrote in message
...
I don't worry about it.

It would be pretty amazing to guess:

ResetVariablesToInitialValues

<vbg

George Nicholson wrote:

Dave:

Thanks, I didn't know that (or if I did, I had forgotten it).

Up to now I've only been concerned with procedures not appearing in the
list. I will have to consider whether that is sufficient. While it
*probably* is, the possibility that a user a) knows about this and b)
somehow learns the name of a procedure/function (even if code is
protected)
is definitely worth consideration. (I will just have to figure out how
much
consideration).
--
George Nicholson

Remove 'Junk' from return address.

"Dave Peterson" wrote in message
...
But if they can find the name of the procedure, they can type the name
of
the
sub in the run dialog.

They can't select it and run it, but they can type and run.



George Nicholson wrote:

In addition to the other answers you've been given, procedures with
arguments and functions that return values can't be run from the
Macro
list,
so Excel ignores them when creating the list. Therefore, simple
workarounds
can also include minor code modifications like the following, which
should
have no impact on how your existing code runs, and doesn't require
changes
to existing module/procedure scoping.

Public Sub MySub(Optional DummyArg as Boolean)
'the argument (even when optional and never supplied) will
prevent
this
from appearing in the macro list.
End Sub

or

Public Function MySub()as Boolean
'the return value (which you don't have to actually use) will
prevent
this from appearing in the macro list.
End Function

--

HTH,

George Nicholson

Remove 'Junk' from return address.

"Alan Hutchins" wrote in
message
...
Hi,

I have a workbook, where the VBA code is password
protected.

The macros within the workbook are operated by buttons -
so I'm happy with that.

However, what I really want to be able to do, is to stop
users from selecting Tools, Macro, and then running a
macro from there (NOTE - I do not want to hide this option
from the Toolbar). Is there any way of preventing users
from running a macro in this way ?

Note - Also, I do not want to protect the workbook either.

--

Dave Peterson


--

Dave Peterson