Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password to access a custom menu?
Hi All,
I need to provide a custom menu for 'administrators' of a spreadsheet. This menu will give them priveleges not available to normal users and therefore l would like to have them enter a password whenever they click on the custom menu (eg ADMIN). I want to avoid having to check for the correct password on each macro as there are too many. The custom menu has been added using: Dim ADMINmenu As CommandBarControl Set ADMINmenu = Application.CommandBars("Worksheet Menu Bar").Controls.add(Type:=msoControlPopup, Befo=8) ADMINmenu.Caption = "&ADMIN" ADMINmenu.BeginGroup = False ADMINmenu.Visible = True Can anybody give me any pointers / code to achieve this please? Regards Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
password to access a custom menu?
Hi All, Must be getting tired, adding this line to launch macro solved the problem ADMINmenu.OnAction = "password_request" Regards Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete specific menu item from custom menu | Excel Programming | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |