How manipulate a picture with recording macros?

[Guest]

In Excel 2003 it was easy to record a macro to modify the properties of a
picture.
It was enought to push "Record Macro" button, and execute all steps we
wanted the macro would do later.
Now, in nExcel 2007, i don't get to do the same!
Am i forgeting to do something?
Please, wait for answer...

 

[Rick Rothstein \(MVP - VB\)]

In Excel 2003 it was easy to record a macro to modify the properties of a

picture.
It was enought to push "Record Macro" button, and execute all steps we
wanted the macro would do later.
Now, in nExcel 2007, i don't get to do the same!
Am i forgeting to do something?

You can do this... click the Office button (the large round icon in the
top-left corner), then click the Excel Options button at the bottom of the
panel that is displayed, then put a check mark in the check box labeled
"Show Developer tab in the Ribbon" (which is located in the top section of
the displayed panel, and then click OK. This will add a new tab to the
Ribbon labeled "Developer"... on that tab (in the Code section) is a button
for "Record Macro" (it becomes a "Stop Recording" button after it is
clicked).

Rick

 

[Rick Rothstein \(MVP - VB\)]

It looks like the Record Macro button can be placed on the left side of the
Status Bar next to the (Cell Mode) Ready indicator. If it is not visible
there at the moment, then you can put it there by right-clicking on the
Status Bar and then clicking on the "Macro Recording" entry in the list that
appears.

Rick