Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined menus and functions!
Hello all!
I was trying to create a menu and attach some stuff to it. For eg, create a menu called 'Basic', with the default Excel GUI, nex to the 'Help' menu. I right clicked the toolbar and using the 'customize' button, I coul implement the above task. I could also attach toolbars to the created menu & assign macros t them. But let's say I want to have couple of extra things within the 'Basic menu so that it looks something like the following. Basic Menu 'Analysis type' ......................Static/Modal 'Results location'....................Node/Element 'Type' ...................................Stress/strain It has to be like a pull-down menu, where the user clicks the Basi menu and the three sub-menus pop up. On clicking the 'Analysis Type which comes within the 'Basic Menu', the user must be able to pick on of the two options . One is 'Static' and other is 'Modal etc............................. I would appreciate your help. Thanks a bunch. Arun... Vtec Cor -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined menus and functions!
See John's example
http://www.j-walk.com/ss/excel/tips/tip53.htm I think you like it -- Regards Ron de Bruin http://www.rondebruin.nl "aiyer " wrote in message ... Hello all! I was trying to create a menu and attach some stuff to it. For eg, create a menu called 'Basic', with the default Excel GUI, next to the 'Help' menu. I right clicked the toolbar and using the 'customize' button, I could implement the above task. I could also attach toolbars to the created menu & assign macros to them. But let's say I want to have couple of extra things within the 'Basic' menu so that it looks something like the following. Basic Menu 'Analysis type' ......................Static/Modal 'Results location'....................Node/Element 'Type' ...................................Stress/strain It has to be like a pull-down menu, where the user clicks the Basic menu and the three sub-menus pop up. On clicking the 'Analysis Type' which comes within the 'Basic Menu', the user must be able to pick one of the two options . One is 'Static' and other is 'Modal' etc............................. I would appreciate your help. Thanks a bunch. Arun... Vtec Corp --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined menus and functions!
I've never done this, but gave it a whirl. I think you can do what yo
want and I'll try to give you the steps I followed: - From Right-Click on meny, select Customize and choose Commands tab. - Select new menu from the categories list - Drag the new menu item from the commands list to the menubar - Drag three more new menu items from the command list - Drag your macros (static/modal, etc.) and put them under the correc new menu items. -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined menus and functions!
Arun,
Why have you posted again? Your earlier post has solutions there. "aiyer " wrote in message ... Hello all! I was trying to create a menu and attach some stuff to it. For eg, create a menu called 'Basic', with the default Excel GUI, next to the 'Help' menu. I right clicked the toolbar and using the 'customize' button, I could implement the above task. I could also attach toolbars to the created menu & assign macros to them. But let's say I want to have couple of extra things within the 'Basic' menu so that it looks something like the following. Basic Menu 'Analysis type' ......................Static/Modal 'Results location'....................Node/Element 'Type' ...................................Stress/strain It has to be like a pull-down menu, where the user clicks the Basic menu and the three sub-menus pop up. On clicking the 'Analysis Type' which comes within the 'Basic Menu', the user must be able to pick one of the two options . One is 'Static' and other is 'Modal' etc............................. I would appreciate your help. Thanks a bunch. Arun... Vtec Corp --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
About User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Programming |