Forum Discussion

Forrest1210's avatar
Forrest1210
Copper Contributor
Jan 14, 2019

Insert gif files into spreadsheet

Hi, I have inserted a gif file into my spreadsheet just as I would any other picture format. The animation does not play once inserted. I am using Exce 2016. It there a way to get the animation to ...
excel
  • Forrest1210's avatar
    Forrest1210
    Copper Contributor
    Jan 15, 2019

    Thanks for the answer. It looked promising, but I can't do the following 3 steps in the https://www.techwalla.com/articles/how-to-insert-animated-gif-files-in-excel article. I do not have the "Toolbars" option on my "View" menu and can't find it to add it from the customize ribbon option in Excel 2016, or in any other menu location.The "Design Mode" is located on the "Developer" tab menu so I do have that. I found a "Control Toolbox" in the Visual Basic menus, but it is greyed out and I can't open it.

    Step

    Click on the "View" menu and choose "Toolbars" => "Control Toolbox."

     

    Step

    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.

    Step

    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.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 15, 2019

      I didn't play with this, but in general 

      File->Options->Customise Ribbon and be sure Developer checked.

      Controls are under Developer tab on ribbon

      • Forrest1210's avatar
        Forrest1210
        Copper Contributor
        Jan 21, 2019

        I am still trying to make gif files work in excel 2016. I have them inserted on an object (Shape that I created as a "viewscreen"), not in a cell. I have tried a solution from the techwalla website but can't make it work. I have included a screen print of the instructions and what I have done, including the VB error message. I believe that I followed the instructions correctly. Can anyone help?

         

        I opened "Design Mode" on my own because the method in the instructions, the commands listed in the steps, are not found in my menus. Because of that, I still can't complete step 5, "Open the Microsoft Web Browser used to view & control the gifs". (Opening Edge or Internet Explorer doesn't seem to help anything.)

         

Resources