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... |
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 |
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 |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com