Add-in macro not shown in Quick Access Toolbar commands

Add-in macro not shown in Quick Access Toolbar commands

I have an add-in (Word 2007) which has public macros and is loaded on
startup. I can view / run the macro pressing ALT+F8. But i would like
to add a button on the QAT but when i goto customize and choose
"Macros" from the "Choose commands from" drop down the macros are not
listed.

What i find odd is that if i hit the "Customize..." button on the
keyboard shortcuts the macros are listed here and I can assign a
keyboard shortcut to them but can't seem to add a button in the QAT?

Any help?

date: Sat, 10 May 2008 20:02:43 -0700 (PDT) author: unknown

Re: Add-in macro not shown in Quick Access Toolbar commands

I see the same thing. I suspect that this was an oversight in creating the 
QAT capabilities. I'll ask Microsoft if it's a bug. It sure seems like one 
to me.

-- 
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


 wrote in message 
news:a0288f50-0ce7-43c5-b9dd-8250a4b9a274@27g2000hsf.googlegroups.com...
>I have an add-in (Word 2007) which has public macros and is loaded on
> startup. I can view / run the macro pressing ALT+F8. But i would like
> to add a button on the QAT but when i goto customize and choose
> "Macros" from the "Choose commands from" drop down the macros are not
> listed.
>
> What i find odd is that if i hit the "Customize..." button on the
> keyboard shortcuts the macros are listed here and I can assign a
> keyboard shortcut to them but can't seem to add a button in the QAT?
>
> Any help?

date: Sat, 10 May 2008 23:33:41 -0400 author: Herb Tyson [MVP]

Re: Add-in macro not shown in Quick Access Toolbar commands

I suspect this may be by design. If you open the startup template in Word, 
then the macro listings it contains become available to the QAT editor. Add 
the command then close the template.

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



ryanmhuc@yahoo.com wrote:
> I have an add-in (Word 2007) which has public macros and is loaded on
> startup. I can view / run the macro pressing ALT+F8. But i would like
> to add a button on the QAT but when i goto customize and choose
> "Macros" from the "Choose commands from" drop down the macros are not
> listed.
>
> What i find odd is that if i hit the "Customize..." button on the
> keyboard shortcuts the macros are listed here and I can assign a
> keyboard shortcut to them but can't seem to add a button in the QAT?
>
> Any help?

date: Sun, 11 May 2008 07:36:37 +0300 author: Graham Mayor

Re: Add-in macro not shown in Quick Access Toolbar commands

On May 11, 12:36 am, "Graham Mayor"  wrote:
> I suspect this may be by design. If you open the startup template in Word,> then the macro listings it contains become available to the QAT editor. Add
> the command then close the template.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor -  Word MVP
>
> My web sitewww.gmayor.com
> Word MVP web sitehttp://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
>
> ryanm...@yahoo.com wrote:
> > I have an add-in (Word 2007) which has public macros and is loaded on
> > startup. I can view / run the macro pressing ALT. But i would like
> > to add a button on the QAT but when i goto customize and choose
> > "Macros" from the "Choose commands from" drop down the macros are not
> > listed.
>
> > What i find odd is that if i hit the "Customize..." button on the
> > keyboard shortcuts the macros are listed here and I can assign a
> > keyboard shortcut to them but can't seem to add a button in the QAT?
>
> > Any help?- Hide quoted text -
>
> - Show quoted text -

Thanks for both of you. That would be great if you could ask Microsoft
about it. If its a bug it would be great to get it fixed. If its by
desing it doesn't make much sense to be able to link it to a keyboard
shortcut but NOT be able to link it to a button. And surely its pretty
laborious to have to open up the add-in to be able to link a button.

date: Sat, 10 May 2008 22:12:07 -0700 (PDT) author: unknown

Re: Add-in macro not shown in Quick Access Toolbar commands

ryanmhuc@yahoo.com wrote:
>
> Thanks for both of you. That would be great if you could ask Microsoft
> about it. If its a bug it would be great to get it fixed. If its by
> desing it doesn't make much sense to be able to link it to a keyboard
> shortcut but NOT be able to link it to a button. And surely its pretty
> laborious to have to open up the add-in to be able to link a button.

If there is sense in it, it is because the QAT is completely new to the 
version, whereas the shortcut key editor is retained from the earlier 
versions. 2007 is a bit of a mish mash of old and new functions and the new 
functions often leave something to be desired. I suspect at least some of 
the shortcomings will be addressed in the next version. If we get a comment 
from Microsoft it will be passed on.

If you still have access to the earlier Word version you may find 
http://www.gmayor.com/Toolbars_in_word_2007.htm useful. Not a convenient 
solution, but a flexible approach to adding tools.

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

date: Sun, 11 May 2008 09:55:17 +0300 author: Graham Mayor

Re: Add-in macro not shown in Quick Access Toolbar commands

Bolstering the idea that it's a bug, if you revisit the QAT customize window 
after adding a macro by opening the startup template directly, after the 
template is closed, you can no longer see where the macro associated with 
the tool resides. This definitely seems like an oversight to me. You should 
always be able to inspect things to find out what's what, and in this case, 
once the startup-based macro has been added to the QAT in the manner 
indicated by Graham, the QAT dialog offers no subsequent trail to the owning 
template.

-- 
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Graham Mayor"  wrote in message 
news:uNJ4yPzsIHA.4476@TK2MSFTNGP06.phx.gbl...
> ryanmhuc@yahoo.com wrote:
>>
>> Thanks for both of you. That would be great if you could ask Microsoft
>> about it. If its a bug it would be great to get it fixed. If its by
>> desing it doesn't make much sense to be able to link it to a keyboard
>> shortcut but NOT be able to link it to a button. And surely its pretty
>> laborious to have to open up the add-in to be able to link a button.
>
> If there is sense in it, it is because the QAT is completely new to the 
> version, whereas the shortcut key editor is retained from the earlier 
> versions. 2007 is a bit of a mish mash of old and new functions and the 
> new functions often leave something to be desired. I suspect at least some 
> of the shortcomings will be addressed in the next version. If we get a 
> comment from Microsoft it will be passed on.
>
> If you still have access to the earlier Word version you may find 
> http://www.gmayor.com/Toolbars_in_word_2007.htm useful. Not a convenient 
> solution, but a flexible approach to adding tools.
>
> -- 
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor -  Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
>

date: Sun, 11 May 2008 09:16:37 -0400 author: Herb Tyson [MVP]

Re: Add-in macro not shown in Quick Access Toolbar commands

On May 11, 9:16 am, "Herb Tyson [MVP]"  wrote:
> Bolstering the idea that it's a bug, if you revisit the QAT customize window
> after adding a macro by opening the startup template directly, after the
> template is closed, you can no longer see where the macro associated with
> the tool resides. This definitely seems like an oversight to me. You should
> always be able to inspect things to find out what's what, and in this case> once the startup-based macro has been added to the QAT in the manner
> indicated by Graham, the QAT dialog offers no subsequent trail to the owning
> template.
>
> --
> Herb Tyson MS MVP
> Author of the Word 2007 Bible
> Blog:http://word2007bible.herbtyson.com
> Web:http://www.herbtyson.com
>
> "Graham Mayor"  wrote in message
>
> news:uNJ4yPzsIHA.4476@TK2MSFTNGP06.phx.gbl...
>
>
>
> > ryanm...@yahoo.com wrote:
>
> >> Thanks for both of you. That would be great if you could ask Microsoft
> >> about it. If its a bug it would be great to get it fixed. If its by
> >> desing it doesn't make much sense to be able to link it to a keyboard
> >> shortcut but NOT be able to link it to a button. And surely its pretty
> >> laborious to have to open up the add-in to be able to link a button.
>
> > If there is sense in it, it is because the QAT is completely new to the
> > version, whereas the shortcut key editor is retained from the earlier
> > versions. 2007 is a bit of a mish mash of old and new functions and the
> > new functions often leave something to be desired. I suspect at least some
> > of the shortcomings will be addressed in the next version. If we get a
> > comment from Microsoft it will be passed on.
>
> > If you still have access to the earlier Word version you may find
> >http://www.gmayor.com/Toolbars_in_word_2007.htmuseful. Not a convenient
> > solution, but a flexible approach to adding tools.
>
> > --
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > Graham Mayor -  Word MVP
>
> > My web sitewww.gmayor.com
> > Word MVP web sitehttp://word.mvps.org
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>- Hide quoted text -
>
> - Show quoted text -

So in the meantime to make it easier for co-workers to use the add-in
i put it into a COM Add-in and Added a tab in the ribbon. This atleast
allows them to add the commands to the QAT. But how can then remove my
"Common Tasks" tab from the ribbon if they so choose? I find this odd
since in all other versions of office you could customize the toolbars
so easily. Thanks for all the help

date: Sun, 11 May 2008 10:42:42 -0700 (PDT) author: unknown

Re: Add-in macro not shown in Quick Access Toolbar commands

> So in the meantime to make it easier for co-workers to use the add-in
> i put it into a COM Add-in and Added a tab in the ribbon. This atleast
> allows them to add the commands to the QAT. But how can then remove my
> "Common Tasks" tab from the ribbon if they so choose? I find this odd
> since in all other versions of office you could customize the toolbars
> so easily. Thanks for all the help

Short of removing the add-in there is no way to toggle the display of ribbon 
items. Love it or loathe it the approach adopted in 2007 is fundamentally 
different from that in earlier versions.

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

date: Mon, 12 May 2008 07:57:29 +0300 author: Graham Mayor