Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to acurrent Excel menu
Hi
A long time ago I knew how to add a new menu to an existing menu bar..It seems that I forgot. There was no VBA or VB.NET You laid our the menu on a spreadsheet in 3 or 4 columns Col 1 was the heading, col 2 was the action etc then you highlighted the entire page, gave it a name and away you went. Can anyone help me with this. I sure need help Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to acurrent Excel menu
Maybe this ?
http://www.j-walk.com/ss/excel/tips/tip53.htm See also http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCOR" wrote in message ... Hi A long time ago I knew how to add a new menu to an existing menu bar..It seems that I forgot. There was no VBA or VB.NET You laid our the menu on a spreadsheet in 3 or 4 columns Col 1 was the heading, col 2 was the action etc then you highlighted the entire page, gave it a name and away you went. Can anyone help me with this. I sure need help Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to acurrent Excel menu
Just GREAT...Many thanks...also thnaks for the VERY FAST response
Ian M "Ron de Bruin" wrote in message ... Maybe this ? http://www.j-walk.com/ss/excel/tips/tip53.htm See also http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCOR" wrote in message ... Hi A long time ago I knew how to add a new menu to an existing menu bar..It seems that I forgot. There was no VBA or VB.NET You laid our the menu on a spreadsheet in 3 or 4 columns Col 1 was the heading, col 2 was the action etc then you highlighted the entire page, gave it a name and away you went. Can anyone help me with this. I sure need help Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to acurrent Excel menu
In Excel 5/95, there was a menu editor. In xl97 up to the current edition,
they changed to commandbars. Now do tools=customize and you can customize you menus using drag and drop as long as the dialog stays open. Look at the second tab of the dialog to use built in controls or create you own customized control After you drag a custom button into place, you can right click on it for further options such as editing the bitmap and assigning macros. -- Regards, Tom Ogilvy "PCOR" wrote in message ... Hi A long time ago I knew how to add a new menu to an existing menu bar..It seems that I forgot. There was no VBA or VB.NET You laid our the menu on a spreadsheet in 3 or 4 columns Col 1 was the heading, col 2 was the action etc then you highlighted the entire page, gave it a name and away you went. Can anyone help me with this. I sure need help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a menu item to Excel | Excel Discussion (Misc queries) | |||
Adding Separator Menu Item - Excel 2003 | Excel Programming | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Adding menu to the mouse right click pop-up menu | Excel Programming | |||
Adding toolbar/menu command to Excel using C# | Excel Programming |