NCAA Men's Basketball Tournament
Bracket Macro Info
| NCAA Men's Basketball Tournament | |
Excel 97-2003
When opening the document, select ENABLE MACROS when prompted to do so. If you are not prompted, check your security settings under: Tools... Options... Security... Macro Security... [set your level to "Medium", then click OK twice]. Once this is done, close Excel completely and reopen the document.
Excel 2007
After the document opens, click on the "Options…" box at the top of the screen. In the following window, click "Enable this content" and then "Ok".
When talking about Microsoft Office (Word, Excel, etc), a macro is a piece of hand-generated code that adds functionality to the software application; the code is written in the "Visual Basic for Applications" language and is part of the Excel file. In the case of the bracket, I wrote code to automatically advance teams through the bracket when you click on the team names; this is not something that Excel does normally, but through macros I could tell Excel exactly what I want to happen.
Good for you to ask. Open the Excel document and press Alt-F11. This will open up the Visual Basic editor, and by clicking on sheet and module names on the left side of the screen you will be able to view all code.