Microsoft Excel 2007 comes with a new feature that allows you to animate objects in cells within your workbook. This feature can be very useful to draw a reader's attention to specific data, or to simply jazz up your spreadsheets which, as we all know, can be very boring. Impress your boss or win that proposal by animating cells within your Microsoft Excel workbook to create a visually stunning masterpiece sure to get the right message across to your clients.
- Skill level:
- Moderately Challenging
Other People Are Reading
Things you need
- Microsoft 3-D Animation Engine
Download the 3-D Animation Engine for Excel---you cannot animate your cells without it (see References).
Select your correct Internet connection from the drop-down menu next to "Estimated Download Time:" and click the "Download" button in the upper left-hand corner of the Quick Details information box.
Save the download file to your computer's desktop and double-click on the saved file to activate the installation.
Install the 3-D Animation Engine, following the prompts provided by the installation wizard.
Download and Install the 3-D Animation Engine
Open the Excel Binary Workbook that was downloaded when you installed the 3-D Animation Engine.
Insert the object you wish to animate by clicking on the "Insert" tab from the Microsoft Office Fluent Ribbon on the Binary Workbook. Select "Illustrations," and click "Shapes."
Pick your shape and click "Animate!"
View the animation by placing a check in the "Step Run?" check box and clicking "Animate!" again.
Change the shape's direction by clicking "Reverse" if you wish. You may also change other parameters of the object by using the Parameter Table in the upper left-hand corner of your worksheet.
Click "Export to Light" once you are satisfied with the animation of your shape.
Open the Lights worksheet to apply lighting and shadow effects to your shape. Your object will automatically appear when you open the Lights worksheet.
Click "Shed Light."
Adjust the light's reflection on your object by using the sun controls on the left-hand side of the worksheet.
Apply different textures to your object using the controls on the top of your worksheet.
Colour your object with the colour controls, and click on the shadow controls at the bottom of your worksheet to create mysterious shadow effects.
Click "Snap" and name your object when you are finished adjusting the lighting effects.
Create Lighting Effects
Open the Recorded Tracks worksheet and your newly-named object.
Open your Visual Basic Editor by pressing on "Alt" and "F11" at the same time.
Select the Microsoft Office Button in the upper left-hand corner of your screen and click on "Excel Options."
Ensure that the "Show Developer tab in the Ribbon" button is selected from the Popular submenu and click "OK."
Click on the "Developer" tab and select "Module2."
Press "F5" to run the code after placing your cursor at the beginning of the Immediate window where the Visual Basic code is shown.
Copy and paste your Visual Basic code results, after they have run, into the cell in your Excel spreadsheet to run your animated object.
Generate Visual Basic Code
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for