Call me a weirdo, but I like R1C1 reference style. It makes sense. Why the hell does most of the world seem to want to label columns with letters? (Anyway, I don't have time to rant, so moving on...)
Here's how to do it:
- Have a workbook open.
- Record some macro and choose to put it in your personal macros workbook.
- Choose Window ... Unhide... to see your personal workbook.
- Just to be doubly doubly sure, I then close all workbooks except the personal one.
- Edit preferences, then save the personal workbook.
Hah! Foiled you again, Microsoft! I will have my preferences the way I want them! At least until I install the next latest version...