Excel 2007

is it possible to put something on the Quick Access Toolbar that will allow
me to run a macro with one click?
--
Gary''s Student - gsnu2007xx

Try this

Right click the QA Toolbar and select Customise.
From the left dropdown choose 'Macros' and scroll to your macro and then
click ADD
On the right click modify and from the popup select an Icon
OK

Mike

"Gary''s Student" wrote:

> Excel 2007
>
> is it possible to put something on the Quick Access Toolbar that will allow
> me to run a macro with one click?
> --
> Gary''s Student - gsnu2007xx

Yes.
Click the drop-down arrow at the right edge of the QAT and choose "More
Commands".
That'll take you to a probably familiar looking window where you can choose
"Macros" in the "Choose commands from:" area. That'll give you a list of
macros to choose from. The macro icon will be a flowchart kind of icon.
Hovering over the icon will show the macro's name as a tip eventually.

"Gary''s Student" wrote:

> Excel 2007
>
> is it possible to put something on the Quick Access Toolbar that will allow
> me to run a macro with one click?
> --
> Gary''s Student - gsnu2007xx

Click on 'Customize QAT'>More commands>select 'Macros' from 'Choose commands
from' drop down will populate any available macros. Select the macro and
click Add will add an icon in QAT.

If this post helps click Yes
---------------
Jacob Skaria


"Gary''s Student" wrote:

> Excel 2007
>
> is it possible to put something on the Quick Access Toolbar that will allow
> me to run a macro with one click?
> --
> Gary''s Student - gsnu2007xx

Thanks!
--
Gary''s Student - gsnu200909


"Mike H" wrote:

> Try this
>
> Right click the QA Toolbar and select Customise.
> From the left dropdown choose 'Macros' and scroll to your macro and then
> click ADD
> On the right click modify and from the popup select an Icon
> OK
>
> Mike
>
> "Gary''s Student" wrote:
>
> > Excel 2007
> >
> > is it possible to put something on the Quick Access Toolbar that will allow
> > me to run a macro with one click?
> > --
> > Gary''s Student - gsnu2007xx

Thanks!
--
Gary''s Student - gsnu200909


"JLatham" wrote:

> Yes.
> Click the drop-down arrow at the right edge of the QAT and choose "More
> Commands".
> That'll take you to a probably familiar looking window where you can choose
> "Macros" in the "Choose commands from:" area. That'll give you a list of
> macros to choose from. The macro icon will be a flowchart kind of icon.
> Hovering over the icon will show the macro's name as a tip eventually.
>
> "Gary''s Student" wrote:
>
> > Excel 2007
> >
> > is it possible to put something on the Quick Access Toolbar that will allow
> > me to run a macro with one click?
> > --
> > Gary''s Student - gsnu2007xx

I should have added that it's probably best to have the macro in your
Personal file, since that icon is going to become a somewhat permanent
addition to the QAT. You have to go through the same Customize process, but
explicitly choose to remove the icon to get rid of it.

"Gary''s Student" wrote:

> Excel 2007
>
> is it possible to put something on the Quick Access Toolbar that will allow
> me to run a macro with one click?
> --
> Gary''s Student - gsnu2007xx

Just to add, if the macro should only be available in a particular workbook,
when adding to the QAT (as others have described) in the top right dropdown
select "For myBook.xlsm". The button will only appear when myBook is
active.

However, due to a bug introduced in SP2, when the file is closed & reopened
the button will no longer appear. Ron de Bruin describes how to fix here -
http://www.rondebruin.nl/qatbuttonbug.htm

Regards,
Peter T


"JLatham" <(E-Mail Removed)> wrote in message
news:4426EDEE-A29C-4A9E-9829-(E-Mail Removed)...
>I should have added that it's probably best to have the macro in your
> Personal file, since that icon is going to become a somewhat permanent
> addition to the QAT. You have to go through the same Customize process,
> but
> explicitly choose to remove the icon to get rid of it.
>
> "Gary''s Student" wrote:
>
>> Excel 2007
>>
>> is it possible to put something on the Quick Access Toolbar that will
>> allow
>> me to run a macro with one click?
>> --
>> Gary''s Student - gsnu2007xx

You're welcome.

Also, if you haven't seen it, you should check out Peter T's response to my
second post in the thread. Has some good added information about managing
that added button
http://www.microsoft.com/office/comm...0-b54ebf267a9a


"Gary''s Student" wrote:

> Thanks!
> --
> Gary''s Student - gsnu200909
>
>
> "JLatham" wrote:
>
> > Yes.
> > Click the drop-down arrow at the right edge of the QAT and choose "More
> > Commands".
> > That'll take you to a probably familiar looking window where you can choose
> > "Macros" in the "Choose commands from:" area. That'll give you a list of
> > macros to choose from. The macro icon will be a flowchart kind of icon.
> > Hovering over the icon will show the macro's name as a tip eventually.
> >
> > "Gary''s Student" wrote:
> >
> > > Excel 2007
> > >
> > > is it possible to put something on the Quick Access Toolbar that will allow
> > > me to run a macro with one click?
> > > --
> > > Gary''s Student - gsnu2007xx

Thanks for the added information, ends up making things work a lot better in
the end.


"Peter T" wrote:

> Just to add, if the macro should only be available in a particular workbook,
> when adding to the QAT (as others have described) in the top right dropdown
> select "For myBook.xlsm". The button will only appear when myBook is
> active.
>
> However, due to a bug introduced in SP2, when the file is closed & reopened
> the button will no longer appear. Ron de Bruin describes how to fix here -
> http://www.rondebruin.nl/qatbuttonbug.htm
>
> Regards,
> Peter T
>
>
> "JLatham" <(E-Mail Removed)> wrote in message
> news:4426EDEE-A29C-4A9E-9829-(E-Mail Removed)...
> >I should have added that it's probably best to have the macro in your
> > Personal file, since that icon is going to become a somewhat permanent
> > addition to the QAT. You have to go through the same Customize process,
> > but
> > explicitly choose to remove the icon to get rid of it.
> >
> > "Gary''s Student" wrote:
> >
> >> Excel 2007
> >>
> >> is it possible to put something on the Quick Access Toolbar that will
> >> allow
> >> me to run a macro with one click?
> >> --
> >> Gary''s Student - gsnu2007xx
>
>
> .
>