Prev: Sum Days into Weeks
Next: equation
From: Darrell on 16 Feb 2010 00:43
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?
From: PJ on 16 Feb 2010 09:58
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?
From: John on 16 Feb 2010 14:04
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" <Darrell(a)discussions.microsoft.com> wrote in message
news:270E69BC-AFEE-47A0-8457-B5610ABF1A1D(a)microsoft.com...
> 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?

 | 
Pages: 1
Prev: Sum Days into Weeks
Next: equation