How to record macro clicks to ribbon bar?

[dplaut]

I'm trying to record a macro to prototype something. The recorded macro ends
up being useless because clicks on the ribbon bar are not recorded. How do
you make a macro record clicks on the ribbon bar?

Office 2007

 

[Gordon Bentley-Mix]

Short answer: you can't. The macro recorder doesn't work this way
unfortunately. You could try using the keyboard alternatives, but they
probably won't be much use either as all the recorder will show is the
keystrokes. But then that's the whole idea behind a macro: to save you from
having to do things like click on the ribbon, open dialog boxes, etc. Best
to learn a bit more about VBA and the Word OM and write quick-n-dirty code
when prototyping because the macro recorder will only be of limited help in
most situations.