Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
input time by keybrd in locked worksheet
What I want to do is have a user input time start and end in a time sheet to
account for worked hours by using a short cut key stroke but I don't want him to be able to just enter anytime he wants. By using the shortcut excel would enter the exact time. Can I do with with locked cell or how else? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
input time by keybrd in locked worksheet
Darrell
The keyboard shortcut for entering the current time is Ctrl-Shift-; This works on locked cells but not if the worksheet is protected. "Darrell" wrote: What I want to do is have a user input time start and end in a time sheet to account for worked hours by using a short cut key stroke but I don't want him to be able to just enter anytime he wants. By using the shortcut excel would enter the exact time. Can I do with with locked cell or how else? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
input time by keybrd in locked worksheet
Hi Darrell
Yes It can be done but with a macro only.Your cells will only lock if your sheet is protected.A simple macro could unprotect the sheet, insert the time in the active cell then protect the sheet, all in less then a second. Post back if you want to go in that direction. P.S. If you want a macro, I would post in the excel.programming group. HTH John "Darrell" wrote in message ... What I want to do is have a user input time start and end in a time sheet to account for worked hours by using a short cut key stroke but I don't want him to be able to just enter anytime he wants. By using the shortcut excel would enter the exact time. Can I do with with locked cell or how else? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Time is locked to General format | Excel Worksheet Functions | |||
Keybrd Shortcut to next worksheet? | New Users to Excel | |||
Can validation input messages be locked in place? | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |