Have a question?

Back to F.A.Q. index . . .

Macros are very simple computer programs that allow the user to execute a series of tasks with the click of a button. The Fantasy Ranker uses customized macros to help you sort your rankings by automating the selection of data and using the “Sort” function in Excel. By default, the macro security level for your Excel program is set to "High," meaning only signed macros from trusted sources are allowed to run. The security settings for your Excel program are there to prevent the accidental running of malicious software in Excel. With a security level of “Medium,” your computer retains its  safety and gives you control over what you macros you allow to run. The macros used in the Fantasy Ranker have been signed and authenticated by Ranker Sports LLC. However, you will not be able to add Ranker Sports LLC as a "trusted source" and will have to manually allow these macros to run when prompted after opening the Fantasy Ranker. If you choose not to change the macro settings, you can still use the Fantasy Ranker, but will have to sort your rankings manually.

Excel 1997-2003 Version

• Open Microsoft Excel.

• Go to the "Tools" menu at the top of your Excel window.

• Open the "Tools" menu and go to "Macro."

• Choose "Security" from the "Macro" menu.

• Choose "Medium" from the "Security Level" tab.

• Click the OK button and restart Excel by closing the program and re-opening it. Your macro security level is now set to "Medium."

Excel 2007 Version

• You have several options when it comes to changing the macro security settings in the newest version of Excel.  The instructions to make these changes are more detailed and can be found in the Fantasy Ranker Instruction Sheet for your product.