View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BernzG[_9_] BernzG[_9_] is offline
external usenet poster
 
Posts: 1
Default Hiding macro menu


What I am wanting to do is hide some macros from others that use my file
as I don't want them to "run" the macro itself. The macro code viewing
is already password protected.

All macros are run by activating buttons on a sheet. Some of these
buttons are hidden from other users. However, if you go to the "Tools /
Macros" menu the macro names are visible here and can be run by anybody.
I do realise I can password protect each of the macros not to be used
by others but was wanting to know if there was a way of hiding them
from the MENU.

Any comments would be appreciated.

Cheers,
Bernz


--
BernzG
------------------------------------------------------------------------
BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949
View this thread: http://www.excelforum.com/showthread...hreadid=389667