Hi NeilT,
I think there is a better answer. I just recorded a macro to change the Enter Option to move right and got some Code. I also did it to make Enter go Down. See the code:
With these two macros in your spreadsheet, you can then create Quick Access Toolbar (QAT) icons to set the Enter Direction just by clicking the QAT icon!! Go to QAT and find the "Choose Commands From" dropdown to select Macros instead of Popular Commands.
To change the decimal places code is:
See the attached where I hope the QAT toolbar has changed. I have 5 icons on it which do the above.
Bookmarks