Mandatory input in Excel
 

How can a cell in a worksheet be made to be a mandatory data input field. as
a .

Mandatory input in Excel
 

Only by not allowing the workbook to be saved or closed before the cell is
filled in.

This would also require that users enable macros which opens a second can of
worms.

i.e. What do you do if users do not enable macros.

Anything else relies strictly on educating your users.

You could just place a message formula in the cell like

=if(and(A1<"",B1=""),"Please enter a value in B1","")

See this google search thread for some code if you wish to go that way.

http://snipurl.com/16bvu

I included several posts from Dave Peterson so browse through them.


Gord Dibben MS Excel MVP

On Mon, 1 Jan 2007 18:47:15 -0800, Vinesh Rao <Vinesh
wrote:

How can a cell in a worksheet be made to be a mandatory data input field. as
a .