Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable Items in Menubar
Hi is it possible to disble some of the menus in the menubar ??? i have created a menubar of my own for a specific workbook so when it opens it enables my custom menubar but still shows the default one. any way of getting rid of the default menu then putting it back when it closes ?? thaks -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=483253 |
#2
|
|||
|
|||
Disable Items in Menubar
See
http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cassy01" wrote in message ... Hi is it possible to disble some of the menus in the menubar ??? i have created a menubar of my own for a specific workbook so when it opens it enables my custom menubar but still shows the default one. any way of getting rid of the default menu then putting it back when it closes ?? thaks -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=483253 |
#3
|
|||
|
|||
Disable Items in Menubar
Application.Commandbars(1).Controls("Tools").Enabl ed = False
and set to True after -- HTH RP (remove nothere from the email address if mailing direct) "cassy01" wrote in message ... Hi is it possible to disble some of the menus in the menubar ??? i have created a menubar of my own for a specific workbook so when it opens it enables my custom menubar but still shows the default one. any way of getting rid of the default menu then putting it back when it closes ?? thaks -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=483253 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Customize toolber tabs | Excel Discussion (Misc queries) | |||
Pivot Table: How can I organize data items in a row? | Excel Discussion (Misc queries) | |||
multiple items in database | Excel Worksheet Functions | |||
Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) |