Using Macros in Word 2007

[iandouglas]

Whats a neat & sexy way of actually firing a macro in Word 2007??

I can add it to the quick access toolbar but thats clunky.

I'd like to fire macros from a button on a new tab on the main ribbon. I've looked at RibbonCustomiser & that allows me to add any command to the ribbon but not macros.

Any clever ideas anyone??

[TonyJollans]

I don't know about neat and sexy but you can create controls on the ribbon that run your own macros. You have to use xml, though.

Or, if you have your own toolbar customizations in a template, they should appear on the AddIns tab of the ribbon.

[iandouglas]

Hi Tony

Thanks for your interest & your reply.

Can you please recommend a simple & cheap tool to help me add my macros to the ribbon?

TIA

Ian

[TonyJollans]

Hi Ian,

I'm not sure I know all of what may be out there. When you say you've looked at RibbonCustomizer, is that Patrick Schmidt's tool (http://pschmid.net/office2007/ribboncustomizer/index.php)? I haven't tried to use it - I really want to work it all out for myself as a learning exercise but never seem to find the time - but I would assume it would allow you to add your own commands. Patrick was the front runner when it came to customizing the ribbon and he is very good. At $30 his tool isn't expensive and he does have a free trial available. As for anything else, I'm sure you can google as well as I can.

If you want a book on the subject I can recommend this one: http://www.amazon.co.uk/RibbonX-Customizing-Office-2007-Ribbon/dp/0470191112 which is very cheap as computer books go.

[iandouglas]

Hi Tony
Yes it is Patrick Schmidt's RibbonCustomizer that I've tried & it works well EXCEPT that I can't add macros to the ribbon with it unless I'm being thicker than normal!
Googling doesn't turn up as many ribbon customisers as I would have thought & I can't find one that will put macos on the ribbon which is why I asked the questions here!
So if anyone knows of a tool that will do the job please tell me.
Thanks for the book link.

Ian

[lfrobes2]

try this:

openxmldeveloper.org/articles/CustomUIeditor.aspx

it's simple to use. you'll just need a tiny wee bit of code but you can add your macro to an existing tab or create a new tab for it quickly. it will also generate the callbacks for you, allowing you to assign your macro to a button.

:)

[Paul_Hossler]

Someone in Excel-land here on VBX asked basically the same question about Excel. Not too difficult to add, but does require XML. These are Excel examples, but the principle is the same


http://www.vbaexpress.com/forum/showthread.php?t=24427

Also there's a CustomUI forum here that has additional information

Paul