Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Customised Menu
Good Afternoon, All.
How can I created a customised menu in Excel 2007? Best Regards, Vanessa Simmonds |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Customised Menu
You could modify the ribbon/QAT.
For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins tab. And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm Vanessa Simmonds wrote: Good Afternoon, All. How can I created a customised menu in Excel 2007? Best Regards, Vanessa Simmonds -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Customised Menu
A simple way is to add a 2007 wrapper so it works in 2003 and 2007
http://tinyurl.com/yz5lkh5 -- HTH Bob "Dave Peterson" wrote in message ... You could modify the ribbon/QAT. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins tab. And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm Vanessa Simmonds wrote: Good Afternoon, All. How can I created a customised menu in Excel 2007? Best Regards, Vanessa Simmonds -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customised User Form with Excel cells. | Excel Discussion (Misc queries) | |||
Old Menu in Excel 2007 | Excel Discussion (Misc queries) | |||
Viewing customised menu icons o PC that they weren't created on | Excel Worksheet Functions | |||
Viewing customised menu icons on at | Excel Worksheet Functions | |||
how do i create a customised numbered list in excel | Excel Worksheet Functions |