Using Copy/Paste Special > Transpose...seems to lose the macro functionality

I am using a macro-enabled single Excel 2007 sheet (attached) to input golfers' hole-by-hole scores and calculate their "Callaway" net score. The sheet works exactly as it should, but the orientation is awkward in that players names are along the top of the sheet (A, B, C,...) while their scores are entered vertically down the column under their names.

I would like to "Transpose" the layout so players' names are listed down vertically (1,2,3,...) and hole-by-hole scores are entered left to right along a player's row.

When I use Copy/Paste Special > Transpose, the layout looks good but I lose 2 aspects of the functionality that worked in the original sheet - the actual "Callaway" net score, and the conditional formatting of a "red" cell when the score value entered for a specific golf hole is greater than twice the course par for that hole.

I have attached a .zip file with the original working Callaway Macro-enabled file named "Have" and the correctly formatted Macro-enabled file named "Want"... but while the "Want" file looks correct, you'll see that it neither calculates the net score nor shows the same red cells that show up in the original file.

Any help with correctly formatting the second sheet ("Want") would be greatly appreciated -

Happening44