PC Review


Reply
Thread Tools Rate Thread

Can you set up custom menus in Excel 2007?

 
 
KRiffe
Guest
Posts: n/a
 
      12th Jan 2008
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?
 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      12th Jan 2008
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" <(E-Mail Removed)> wrote in message news:AAA89956-BC30-4ADF-B1D3-(E-Mail Removed)...
> 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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Custom Right Click Menus for Connectors and Shapes Joe B. Microsoft Excel Programming 4 17th Mar 2009 01:48 PM
Excel 2007 Custom Right Click Menus for Connectors and Shapes - Re Joe B. Microsoft Excel Programming 0 17th Mar 2009 11:34 AM
Custom Menus in 2007 Larry Salvucci Microsoft Access 1 5th Dec 2008 10:14 AM
Custom Menus With Excel 2007 =?Utf-8?B?TWlrZSBILg==?= Microsoft Excel Programming 1 13th Nov 2007 12:45 AM
Excel 2007 - Custom menus is missing! =?Utf-8?B?U8O4cmVuIFRoYWRlIFBldGVyc2Vu?= Microsoft Excel Misc 3 11th Jul 2006 01:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:30 AM.