I have done this before a long time ago, but cant remember how i d
 

I created an expense report template in excell years ago. I locked only the
cells that had formulas. But I found people were still forgeting to fill in
certain cells of the report. So I made it so they could not tab to the next
cell until they filled in the cell they were on and so on. I forget how I did
it.

I am pretty sure it wasnt a macro, because i am not good with them, can
anyone help

Wkmooreh