Hello Excel Friends, I need helllllp! I have a few things i need in order to be D-O-N-E with this sheet im creating
1. I have a workbook that allows employees to clock in there is a clock in button on the upper left hand side that records when pressed the time current time is added to the cell . what i want to do is allow users to clock in but once clocked in no changes can be made to that cell , like right now they can actually edit the cell and make changes so if they want to add more time they can, any ideas what i can do?
2. I want to make all my sheets invisble but i also need them to work with my combo boxes so that when i searching for them by name i can find them.
3. i have a schedule worksheet, i cant figure out how to calculate the hours. For example if employee 1 worked 9am - 5pm i want the H box to say 8hours , when i enter the following formula in cell f10 =e10-d9 i get a error message
and last i want to disable right click .
Can someone pleasssse help me, I created the enter sheet but been supppppper stuck on those 4 things.
the worksheet is attached and the password to get in is KioskLog (captial K and L) enter it twice and the password for every thing on the sheet is set to password
Bookmarks