Dancing Workbook

Learn how to Gangnam style with your spreadsheet! As you resize the dancer will adjust to the new window size.

Dancing in Action

Download the workbook for Excel.

 

How to USE:

VBA source code is included … its a simple VBA routine that does the dancing. The sheet is protected but there isn’t a password so all you have to do is click unprotect sheet on the review tab to be able to customize the workbook.

Remember: as with all Excel files that have VBA, after downloading you must unblock the code. From there you can enable macros and customize the workbook.

Multiple Dancers:

Here’s a workbook that has 2 dancers. To do this:

  • In the VBA SetupDance sub, set MAXDANCERS= 2
  • In the sheet, have the dancers in a picture on the grid and name them “dancer_1”, “dancer_2”, and so forth.
  • Save and reopen the workbook!