Can you set up custom menus in Excel 2007?
 

Recently changed from Office 2003 to Office 2007. In Excel 2003 had added
several macros to a personal workbook an built a custom menu with macro
buttons tied to the individual macros so could point and click to open /
access my continually used files. Can't find out how to replicate that in
2007.

Have figured out where personal workbook is and have copied prior macros
into that module. Need to figure out how to do the next steps and haven't
found it in any of the help functions yet.

Can it be done? if so, how?

Can you set up custom menus in Excel 2007?
 

Hi KRiffe

Try this for a easy way
http://www.rondebruin.nl/qat.htm

Or add a menu to the ribbon
http://www.rondebruin.nl/ribbon.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"KRiffe" wrote in message ...
Recently changed from Office 2003 to Office 2007. In Excel 2003 had added
several macros to a personal workbook an built a custom menu with macro
buttons tied to the individual macros so could point and click to open /
access my continually used files. Can't find out how to replicate that in
2007.

Have figured out where personal workbook is and have copied prior macros
into that module. Need to figure out how to do the next steps and haven't
found it in any of the help functions yet.

Can it be done? if so, how?