I have a time log tracker set up and need to have start and stop times entered to calculate production times, but I don't want the employees to be able to enter times manually. I want to limit the entry to the CTRL SHIFT ; shortcut to eliminate fraud.
I am a beginner at macros and VBA and appreciate any help.
I have attached a copy of the spreadsheet and unlocked Sheet "Mon"
Thanks for the replys, but that is not what I am looking for, we already use the shortcut keys for entering the time and I do have the colomns locked in the sheet I use. I want to restrict the time entrys to only use the shortcut key and not allow manual entry.
Is that not what i did with my last reply? You should lock the cells that the time goes into. Then when they want to input the times they cannot unless they press "Ctrl+Shift+T"
Which columns do the times go into?
Would you be able to input some example data in your workbook on the Mon sheet?
You can if you highlight the start time cell and press "Ctrl+Shift+T" this shortcut runs the macro i made to unlock the cell, time stamp the cell, then lock the cell in one go so that it cannot be tampered with.
If you lock the cells and Protect the worksheet with UserInterfaceOnly set to True, then the user won't be able to alter the cells' contents without using a macro.