Making Cell Entry Mandatory

[Sue T]

Hello:
I am using Excel 2003 and would like to make cell entry mandatory in the
first 3 columns of my spreadsheet (exp. Column A, B & C). The following
columns mean nothing unless information is put in the first 3 columns. Is
there a way to set up these columns so that nothing else can be entered until
there is something put in the first 3 columns. Thank You for your help!

 

[StinkeyPete]

This can be done in a VB event function.

 

[Sue T]

Great, Do you know what that would be. Not to efficient in VB. Thank You

 

[StinkeyPete]

I would need more info about your columns in your spreadsheet to give you the
correct code. How many columns are dependant on the 3 required fields?

 

[Sue T]

Hi - 14 columns from D to Q Thank YOu

I would need more info about your columns in your spreadsheet to give you the
correct code. How many columns are dependant on the 3 required fields?