Forum Discussion
How to set tab order of cells in Excel
One possibility is to use sheet protection (with a null password) and allow unlocked cells only to be selected.
PeterBartholomew1 I did see that idea online but I don't think that would work when I'm done entering timesheet hours and then going back to the top to enter billable and non-billable hours (which I intended to use a variation of the tab ordering on; i.e., B2 to B3 to C2 to C3 and so on). Even with multiple sheet protections (one for the time, another for the billable -- is that even a thing?), it still wouldn't create the proper sequence that I'm looking for.
Fair enough. It looks like it's back to VBA then. The trick is to get the right balance between helping the user and appearing over-controlling. Also the addressing needs to be sufficiently robust that adding an employee doesn't wreck the functionality.
