I’ve all the time appreciated the truth that older variations of Excel had hidden video games tucked away inside them. Microsoft stopped doing that years in the past, however Excel customers by no means fully stopped having enjoyable with spreadsheets. I just lately discovered an open-source Area Invaders-style recreation that runs fully inside Excel.
Excel used to cover video games in plain sight
However the Easter eggs finally disappeared
Microsoft snuck some genuinely sudden video games into older variations of Excel. Excel 95 had the Corridor of Tortured Souls, a Doom-style 3D maze, Excel 97 had a flight simulator (pictured above), and Excel 2000 had a driving recreation referred to as Dev Hunter.
However that custom did not final. In 2002, Invoice Gates informed Microsoft staff that Reliable Computing had change into the corporate’s highest precedence, with a selected deal with safety and reliability. Across the similar time, newer variations of Excel stopped delivery with these sorts of hidden video games. This meant we misplaced the intrigue and pleasure of discovering that the spreadsheet program we use for budgets and studies accommodates a wholly pointless online game.
Microsoft is not the one firm to have turned a spreadsheet into a spot for video games. Again within the 2000s, an OpenOffice Calc Easter egg allow you to play a Area Invaders clone instantly in a spreadsheet. Twenty years later, due to VBA and somebody’s laborious work, I discovered myself doing primarily the identical factor in Excel.
Play “Area Defenders” in Excel
Flip your spreadsheet into an arcade machine
Evanml2030’s Excel-SpaceInvader mission on GitHub is an open-source VBA model of the basic arcade recreation. Obtain the macro-enabled Area Defenders workbook, open it in desktop Excel, and play instantly contained in the workbook.
Macro-enabled Excel information might be malicious, so all the time double-check what you are opening first. I opened this file in Secure Mode (by holding Ctrl as I opened Excel) and inspected its VBA (Alt+F11) earlier than I performed it. For extra particulars, scroll to the Safety part beneath.
It is rather more recognizably Area Invaders than I anticipated. You progress your ship backward and forward, fireplace on the incoming enemies, and attempt to clear them earlier than they attain you. The controls are easy: use the Left and Proper Arrow keys to maneuver and the Spacebar to fireside. The sport runs inside Excel’s regular window, with the workbook successfully changing into the sport display. If you get hit, you are greeted with an abrupt “Uh oh, collision detected” alert, and you’ll click on Launch to play once more.
On one playthrough, I did encounter a glitch the place a falling object instantly appeared subsequent to my rocket and ended the sport. Aside from that, although, it labored excellently and performed like a correct arcade recreation.
get began
For those who’ve learn the safety info beneath and are comfy continuing, obtain the XLSM workbook from the mission’s GitHub web page. In Home windows File Explorer, right-click the file and choose Properties. On the Basic tab, look below Safety, test Unblock, and click on OK.
You will additionally must allow ActiveX controls in Excel for the sport to work. Open a clean workbook, go to File > Choices > Belief Middle > Belief Middle Settings > ActiveX Settings, choose the choice you need, and click on OK. As soon as that is completed, shut the clean workbook, open the Area Defenders workbook, and allow its macros and ActiveX controls if prompted.
Bear in mind to alter your ActiveX settings again whenever you’ve completed taking part in. This setting applies to Excel usually, somewhat than simply this workbook, so leaving it modified can have an effect on how Excel handles ActiveX controls in different information.
There is a stunning quantity of code behind it
Excel is doing way over displaying just a few photos
For me, the fascinating half was seeing how the sport truly works. The VBA handles the sport state, motion, enemies, bullets, collisions, timing, and the repeated updates wanted to make all the pieces seem to maneuver easily.
It makes use of DoEvents, which permits Excel to course of different occasions whereas the sport is operating. With out that, a VBA routine that regularly loops via the sport would shortly make Excel really feel unresponsive.
The mission additionally calls a few Home windows API features. GetAsyncKeyState, from user32.dll, is used to detect keyboard enter, whereas QueryPerformanceCounter and QueryPerformanceFrequency, from kernel32.dll, are used for high-resolution timing.
The graphics are dealt with in an particularly Excel-ish manner. The sport dynamically creates Microsoft Kinds Picture.1 ActiveX controls and makes use of them to show the varied sprites. In different phrases, these issues flying across the display aren’t some particular Excel game-rendering system. They’re controls being created and manipulated by VBA.
I discover that extra fascinating than the truth that you possibly can play the sport itself. Somebody has successfully constructed a small arcade-game framework inside a spreadsheet app.
Safety: Opening a macro-enabled file from the net
On this case, I did not discover something regarding
Earlier than taking part in, I inspected the workbook’s VBA to see what it was truly doing. I did not discover code that launches exterior applications, makes community requests, reads or deletes information, modifies the Home windows registry, or makes use of apparent code obfuscation. I additionally did not discover an computerized Workbook_Open() or Auto_Open() routine.
The Home windows API calls I discovered are used for the sport itself: GetAsyncKeyState handles keyboard enter, whereas QueryPerformanceCounter and QueryPerformanceFrequency present high-resolution timing. The ActiveX controls are used to show the sport’s pictures.
That does not imply it’s best to routinely belief each macro-enabled Excel file you obtain. It implies that, on this specific workbook, I did not discover something that appeared to do something past run the sport.
Microsoft disables ActiveX controls by default in Microsoft 365 and Workplace 2024, so you could encounter extra safety warnings when opening the workbook. That is one other good purpose to deal with downloaded macro-enabled information with warning.
Excel is a playground
You need not know VBA or construct a complete recreation inside Excel to get inventive with it. I’ve used Excel’s humble grid to get inventive in some surprisingly other ways, like making pixel artwork, planning a room, making a stop-motion animation, designing a board recreation, and even mapping out a crochet sample. You simply need to cease considering of Excel as someplace you solely put numbers.
