Forum Discussion
How to set tab order of cells in Excel
I've been searching for a method to set the tab order in my sheet. In this situation, I'm entering the time for hourly employees (skipping over the salaried employees), so it would go B4 to D4 to F4...
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.