Animated GIF file into excel by following the Steps Below:-
- You First need to insert the image into a control.
- To insert the control,you need to go View menu-->Toolbar -->Control Toolbox
- Then Activate the Design mode
- Choose the button(the one with a hammer), then select Microsoft Web Browser.
- Draw a frame to receive the image.
- Disable the first button Design mode and the toolbar.
- In VBA editor and in the window of the paper concerned paste the following code:
Private Sub Worksheet_Activate()WebBrowser1.Navigate "X:\Full path of the image.GIF"
End Sub
Change the active page of the spreadsheet, and then return on the page containing the animation, to see your animated GIF file is working or not.
Comments
Post a Comment