Custom drop down menus

S

SDeVuyst

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
 
D

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
 
Top