View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SmartyPants SmartyPants is offline
external usenet poster
 
Posts: 26
Default Cell Restrictions

How do you restrict a cell so that only certain data can be entered?

For example: I need to protect a cell in a fashion that only a date can
be entered.

I'm having problems with people entering formulas in for the date and I
want to restrict them from doing this (it messes up everything).

Any help would be appreciated

thanks