How to access macros via tool buttons?
in [Programming]
|
Prev: Oh, I forgot to say...
Next: using the cells property for use with Application.WorksheetFunction.Sum
From: Mel on 27 May 2010 09:40 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
From: Ron de Bruin on 27 May 2010 11:17
Hi Mel See http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mel" <mel.turco(a)yahoo.com> wrote in message news:86d15545-66fe-4a25-9e00-3a8d6ba34f09(a)w3g2000vbd.googlegroups.com... > 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 |