PC Review


Reply
Thread Tools Rate Thread

How to access macros via tool buttons?

 
 
Mel
Guest
Posts: n/a
 
      27th May 2010
Excel v2007

When using v2003, I had many macros In my Personal.xls, which I
accessed via custom tool buttons on many custom toolbars that I built.
I now have version 2007, which includes my old Personal.xls with all
my macros, but I want the easy access to those macros I used to have.
Being the tool ribbon is a different system, what is now the strategy
for fast button-clickable launching of macros? Are buttons built,
menus, what?

[I already know about the Quick Access Toolbar, but I have over a
hundred macros I previously had divided onto several toolbars that I'd
hide and show as needed. I don't think the QAT will be practical.]

Thanks,
Melina
 
Reply With Quote
 
 
 
 
Harald Staff
Guest
Posts: n/a
 
      27th May 2010
Hi Melina

See Ron's page http://www.rondebruin.nl/qat.htm

and if not
http://www.rondebruin.nl/ribbon.htm
http://www.andypope.info/vba/ribboneditor.htm

HTH. Best wishes Harald


"Mel" <(E-Mail Removed)> wrote in message
news:86d15545-66fe-4a25-9e00-(E-Mail Removed)...
> Excel v2007
>
> When using v2003, I had many macros In my Personal.xls, which I
> accessed via custom tool buttons on many custom toolbars that I built.
> I now have version 2007, which includes my old Personal.xls with all
> my macros, but I want the easy access to those macros I used to have.
> Being the tool ribbon is a different system, what is now the strategy
> for fast button-clickable launching of macros? Are buttons built,
> menus, what?
>
> [I already know about the Quick Access Toolbar, but I have over a
> hundred macros I previously had divided onto several toolbars that I'd
> hide and show as needed. I don't think the QAT will be practical.]
>
> Thanks,
> Melina


 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      27th May 2010
Hi Mel

See
http://www.rondebruin.nl/qat.htm

--

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



"Mel" <(E-Mail Removed)> wrote in message news:86d15545-66fe-4a25-9e00-(E-Mail Removed)...
> Excel v2007
>
> When using v2003, I had many macros In my Personal.xls, which I
> accessed via custom tool buttons on many custom toolbars that I built.
> I now have version 2007, which includes my old Personal.xls with all
> my macros, but I want the easy access to those macros I used to have.
> Being the tool ribbon is a different system, what is now the strategy
> for fast button-clickable launching of macros? Are buttons built,
> menus, what?
>
> [I already know about the Quick Access Toolbar, but I have over a
> hundred macros I previously had divided onto several toolbars that I'd
> hide and show as needed. I don't think the QAT will be practical.]
>
> Thanks,
> Melina

 
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
How to access macros via tool buttons? Mel Microsoft Excel Misc 2 27th May 2010 04:16 PM
make custom buttons for macros on quick access bar excel 2007 shieber Microsoft Excel Misc 2 28th Apr 2008 03:57 PM
make custom buttons for macros on quick access bar excel 2007 shieber Microsoft Excel Misc 0 28th Apr 2008 12:45 PM
Modern looking buttons? (not tool bar buttons) johnb41 Microsoft VB .NET 6 1st Dec 2005 07:21 PM
Access Freezes when Macros Run from Buttons =?Utf-8?B?TWljaGFlbA==?= Microsoft Access Macros 0 22nd Dec 2003 12:06 PM


Features
 

Advertising
 

Newsgroups
 


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