OP
EFX
Contributor
While playing around with the spreadsheet I noticed on the VER sheet I did not add the version information for v34.2. I added the information and updated the website. Here is the link if you want to download it:
ecfehlau.wixsite.com
If you are a little familiar with Excel you can make the changes yourself. Follow these steps:
1. Open the spreadsheet and click on the VER tab. The tabs are on the bottom of the sheets.
2. Click in the cell that says 34.1.
3. Find the insert menu and click on add a row above. This should create a blank row above the 34.1 row.
4. Click on the empty cell for the version and enter 34.2. Click on the B in the menu if it is highlighted. This turns off bolding.
5. Click on the cell for date and enter 11-Mar-22. Unbold this cell.
6. Click on the cell for description and add the following:
Moved the spreadsheet color settings from the VBA code to the SETTINGS sheet.
7. Unbold the cell and save the VER sheet.
HOME | My Site
If you are a little familiar with Excel you can make the changes yourself. Follow these steps:
1. Open the spreadsheet and click on the VER tab. The tabs are on the bottom of the sheets.
2. Click in the cell that says 34.1.
3. Find the insert menu and click on add a row above. This should create a blank row above the 34.1 row.
4. Click on the empty cell for the version and enter 34.2. Click on the B in the menu if it is highlighted. This turns off bolding.
5. Click on the cell for date and enter 11-Mar-22. Unbold this cell.
6. Click on the cell for description and add the following:
Moved the spreadsheet color settings from the VBA code to the SETTINGS sheet.
7. Unbold the cell and save the VER sheet.
