format cell for keyboard short cut entry only?

  • Thread starter Thread starter Darrell
  • Start date Start date
D

Darrell

I want to set up an excel worksheet so that the only way to input the time is
either thru a keyboard shortcut or better yet a mouse click. I want to make
sure the time entered is the correct time.
 
Darrell
Are you saying that you want to preclude the user entering the time
manually (by typing it in)? If so, the only way to do that is to lock the
specific cells, and protect the sheet, allowing selection of locked cells,
then writing a macro that would run if a cell in the specific range is
selected. That macro would unprotect the sheet, enter the time in the
selected cell, and protect the sheet. Post back if this is what you want.
Specify the range of cells in which you want this to work. Something like
"any cell in column F after row 5". Include the version of Excel you are
using. HTH Otto
 
Back
Top