One thing that I do is require a passed variable on each function or
sub, by having requireing a passed variable, the macro won't show up in
the list.

something like this

Public Sub SomeMacro(x as byte)

You can call SomeMacro you would call it like this:
SomeMacro(x)

I declare x like this usually
Public x As Byte 'used to pass to macros to keep them out of the
macro list

Hope that helps.

theSquirrel



On Dec 12, 2:10 pm, Jim Jackson
wrote:
If you have your code modules protected with a password, no one should be
able to view the macros. At least they will not be able to see the code,
even if they are able to see the list of macro names.
--
Best wishes,

Jim



"Sjakkie" wrote:
Is there a way to block the option macro in the menu "tools", "macro". The
sortcut is alt +f8. The reason i want to block this is so that no one can run
the macros in the sheet apart from the macros which are linked to buttons
within the work sheet. The option under tools allows the user to select which
macro to run and this is something i want to stop.- Hide quoted text -- Show quoted text -