How to access macros via tool buttons?

M

Mel

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
 
M

Mel

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

Sorry, I meant to post this to the Excel programming group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top