Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing entry into validation cell
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing entry into validation cell
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. -- HTH... Jim Thomlinson "Bfrank" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forcing cell entry with validation | Excel Discussion (Misc queries) | |||
Forcing an entry | Excel Discussion (Misc queries) | |||
Checking & Forcing Data Entry in Cells | Excel Discussion (Misc queries) | |||
Validation to force entry in a cell | Excel Worksheet Functions | |||
Forcing Combo box entry in VBA | Excel Discussion (Misc queries) |