Forcing entry into validation cell

B

Bfrank

I have a spreadsheet for data entry that will be posted to the web for people
to download and fill in information at their convenience, but I want to make
sure that when they send the data back to me they input their name on the
sheet in a cell designated for their name.

Is there a way I can force them to enter a name into a cell on the sheet? I
can place validation on the cell, but it will not actually kick in until they
enter that cell to edit data in it. Is there a way I can force them into
that cell and not allow them to continue or back out without putting their
name in?
 
J

Jim Thomlinson

In general the answer is no. You can not force anyone to do anything. Yes
there are some ways to force things with macros but generally you are better
off avoiding that kind of thing. You can use a conditional format to
highlight areas that need to be filled in or why not just check the Last
Saved By property of the File.

File -> Properties -> Statistics tab.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top