View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Josh Josh is offline
external usenet poster
 
Posts: 103
Default Forced Cell Input in Excel 2002

I'm working on a spreadsheet that is shared by dozens of users, but the data
input is reviewed by a few of us. To make our trip through the data quicker,
I'm looking for a way to generate an error if they do not fill in certain
fields in the document. Some of the fields are optional, but some should be
mandatory. How do I force them to fill out those fields or get an error
message?

Thanks