Prev: Page Margin issue
Next: About wrapping style, inlineshapes,shapes, and command buttons
From: dplaut on 8 Feb 2010 17:41
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
From: Gordon Bentley-Mix on 8 Feb 2010 18:00
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.
--
Cheers!

Gordon Bentley-Mix

"dplaut" <dplaut(a)discussions.microsoft.com> wrote in message
news:49D88220-E30A-42E0-B088-0E9A8423B73A(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Page Margin issue
Next: About wrapping style, inlineshapes,shapes, and command buttons