theSquirrel
12/12/2006 11:16:00 PM
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 <JimJack...@discussions.microsoft.com>
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 -