Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macro menu
If you are assigning the macros to the buttons manually then, after assigning
the macros, put the key word "Private" in front of each "Sub" statement. Afterwards, they will no longer appear in the Macros menu. If you are assigning the macros programmatically then they can already be termed "Private Sub XYZ" and this won't affect the assignment. Alternatively, put the statement "Option Private Module" at the top of the module. This way all subs in the module will be made private and won't require the Private statement. Regards, Greg "BernzG" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macro menu
Hi Greg, Thanks for this - so simple. Works perfectly. I should have realised this myself as my userforms don't appear in the menu. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding the Menu bar | Excel Programming | |||
hiding the Menu bar | Excel Programming | |||
Hiding Drop Down menu | Excel Programming | |||
hiding Worksheet menu bar | Excel Programming | |||
hiding Worksheet menu bar | Excel Programming |