View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Corrupting a Cell

Hi
have a look at 'Data - Validation'. See:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Stumpy" schrieb im Newsbeitrag
...
Is there a way to prohibit a user from using a space bar in a cell or

from using the delete key to erase a value. Have managers that fill
out a log sheet each day, at the beginning of the next day they clear
the old information using the space bar or the delete key and it messes
up the totals at the end of the form. I want restrict the cell to
accept only a decimal value number.