EXCEL+Add+images+and+assign+a+macro

= EXCEL 2007 =
 * Adding Images and Assigning Macros to Automate a Task **

While using Excel, you may find yourself repeating the same tediuos task over and over. Macros can be used to automate these taks to make your life easier and save time! Below, I will give a brief introduction to recording and using macros in Excel.

I will show you how to create a macro in which it will automate the task of saving the file by clicking an image that is embedded in the Excel sheet.

1.) Open a new Excel document and save onto your desktop with file name Save.and insert an image of your choice. (You may add image from clip art, a location from the computer, or you can copy and paste)

2.) After formating the size of your image, right click to access the shortcut menu, and choose **ASSIG__N__ MACRO**. The dialog box below should appear.

3.) Now under **Maco Name**, remove **Picrture1_**Click and replace with **Save File**. This will be the name of this particular macro. 4.) Hit record. This will now start recording user-invoked events that occur in Excel 5.) Now click the Microsoft Office button, and click**Save** 6.) When the **Save** dialogue box appears, save the file in the destination you would like. However, make sure to save as "**EXCEL MACRO ENABLED WORKBOOK(*.xlsm)"** (see below), otherwise the macro will not be saved. Just remember, a macro is an automated task which will cause it to save at this location everytime. 7.) After saving, return to the sheet. Click **View** on the ribbon and select **Macros** (all the way to the right), and select **Stop Recording.** This will confine the function of the macro of clicking the image to simply saving the worksheet.

8.) Now click the image--it will save the file!!!


 * Macros are set of recorded commands that perform a repeated task. You have created a very simple macro that completes a very simple task. However, macros can complete much harder tasks and are often used in the business world to promote speed and efficiency.**