Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How manipulate a picture with recording macros?
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How manipulate a picture with recording macros?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How manipulate a picture with recording macros?
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 "Rick Rothstein (MVP - VB)" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macros to manipulate drawn objects | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
Macros not recording | Excel Discussion (Misc queries) | |||
Recording macros | Excel Programming |