Excel Macros Instructions - McGee Surname DNA Project

These Excel tools have been superceded by the javascript based tools in the
Y-DNA Comparison Utility

Excel Macros for DNA Tables - Instructions

Load Excel file (Save this file to disk, then open after saving so it doesn't open in your web browser)
Enable Macros prompt box may appear. Select "Enable Macros"
- If you see a Microsoft Excel popup window that says "Macros in this workbook are disabled because the security level is high..." then you will need to change the security level to medium in order to execute these macros.
  From the Tools menu, Select Macro -> Security...
  A Security popup window will appear. Select "Medium", then OK.
  You must close Excel then reopen the file to have the new security level take effect. Now, the Enable Macros prompt box will appear when you open "DNA_Table.xls". Select "Enable Macros."
The initial table should look like this:
Select the area for which you want to compare DNA values.
Select the Macro menu to display the available macros.
Select the macro to use for identifying the reference DNA values.
- prompt box will appear if you chose the "SetBGColorAnyRow". Enter the desired reference row number.
The table highlighting DNA differences should look like this
If you want to write the table to a file then
Select the area that you want to convert to an HTML table.
Select the Macro menu, as described above
Select the "WriteHtmlTable" macro.
will appear. Select OK.
From "My Computer" on your desktop, open the "C:" drive and double click on "DNA_Table.html"
Your browser should look like this:

Page last updated on February 1, 2004