ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding menus! (https://www.excelbanter.com/excel-programming/294498-adding-menus.html)

aiyer[_8_]

Adding menus!
 
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


Greg Koppel

Adding menus!
 
Hello Arun,

I assume that means you found the New Menu item in the customization dialog.
Just add 3 subNew Menus under the main New Menu and then populate the subNew
Menus with the actual buttons you want to assign macros to.

HTH, Greg

"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/





All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com