ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom drop down menus (https://www.excelbanter.com/excel-discussion-misc-queries/32461-custom-drop-down-menus.html)

SDeVuyst

Custom drop down menus
 
Hi. I once saw a spreadsheet that had its own drop-dpwn menus (like File,
Edit, ect, but it had Invoice and things like that). Is that a special add-in
or can it be done straight in Excel somehow? Any ideas? Thx

Damon Longworth

View - Toolbars - Customize - Commands tab - scroll down categories to New
Menu - drag the "New Menu" from the commands to your menu bar. Drag addition
sub-menu items under this new menu item. Right click on the new menu items
and change the name / assign macro.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"SDeVuyst" wrote in message
...
Hi. I once saw a spreadsheet that had its own drop-dpwn menus (like File,
Edit, ect, but it had Invoice and things like that). Is that a special
add-in
or can it be done straight in Excel somehow? Any ideas? Thx





All times are GMT +1. The time now is 11:07 PM.

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