Thursday, November 22, 2012

How to Insert Animated GIF Files in Excel


1. Navigate to the folder that contains your animated GIF file. Write down the full path name of the folder and the name of the file. For example, if the file is contained in a subfolder of your C: drive called Pictures and the file name is bear.gif, then the full path name would be c:\pictures\bear.gif.
2. Open the Microsoft Excel document to which you would like to add your animated GIF.
3. Click on the 'View' menu and choose 'Toolbars' => 'Control Toolbox.'
4. Click on the top button in the 'Control Toolbox,' which activates 'Design Mode.' 'Design Mode' allows you to draw an item in your spreadsheet that may receive an object such as an animated GIF.
5. Click on the bottom button in the 'Control Toolbox,' which has a hammer. From the drop-down menu, select 'Microsoft Web Browser.' This activates 'Microsoft Web Browser' controls, which can be used to view animated GIFs.
6. Left-click and hold down your mouse button on the location in your spreadsheet in which you would like to embed the animated GIF. Draw a box that is large enough to contain the animated GIF image.
7. Click on the 'Design Mode' button again to disable design mode. Close the 'Control Toolbox' toolbar.
8. Hold down the 'Alt' key on your keyboard and press the 'F11' key. Doing so will open a Microsoft Visual Basic window within Excel.
9. Double-click on the worksheet to which you are adding your animated GIF in the Project list in the upper-left corner of the Visual Basic window. This will open a Visual Basic Code window.
10. Copy and paste the following code into the Code window:Private Sub Worksheet_Activate()WebBrowser1.Navigate 'C:\pictures\bear.GIF'End SubChange the path name and filename in quotes to the appropriate path for your animated GIF file.
11. Click to a different worksheet, and then click back to the worksheet to which you added the GIF. The animated GIF should be visible in the object box that you drew.

Blogger news