Quote:
Originally Posted by wardw
***
I tried to create a macro I called Test1 to simply open the Styles dialog. While the macro was recording, I opened Home, then clicked the arrow in Styles to open the dialog. Then I stopped recording. The macro that appeared in VBA looks like this:
Sub Test1()
'
'Test1 Macro
'
'
End Sub
So no commands were recorded. When I closed the Styles dialog, then tried to run the macro, nothing happened.
I suspect there's a problem with dialogs and VBA. Any ideas on why this didn't record?
|
This is how it works (or does not work). There are a number of things that the recorder will not pick up. Even those it does pick up often create poor coding.
See
How to Modify a Recorded Macro by Jay Freedman.