Mandatory Cells

Hi I have a spreadsheet which I'm using a as a form for people to fill in order requests. I have a problem where people don't always input information in the required cells and other times they put in the wrong information. I've solved that latter by using drop down lists, however i would like to make several cells mandatory. In that I mean they can't leave them blank and are prevented from saving the form. Some of the mandatory cells will have drop down lists and others just require something entered into the cells. Finally most of the cells are actualy 2 or three merged together. I can change this if merged cells are a problem. I've seen some VBA scripts but none seem to work and I should point out that I'm no VB guru.

Can anyone help me out please?

Kind regards,

You could try having the cells checked before saving.
With macros opened, double click on "This Workbook" (left hand side)
With the window that opens, in the left drop down box, select "Workbook"
Then in the right hand one, select "Before Save"
Then, have code check the relative cells, and if the cells are empty (or incorrect), cancel the save procedure.

Thank you Paul,

Unfortunately you are talking double dutch to me. Do you have a script that I can cut and paste into the VBA window?

Okay, see file attached.

This checks 3 cells to ensure they're not empty.
If any are, it gives you an error message and you can't save the sheet.
Similar events can happen before printing etc.

You could also easilyget the code to check for the type of input.

Please Login or Register  to view this content.

Cheers,

Paul

Sorry, think the file dropped off. Here 'tis

Thank you Paul, that works fantastic.

I have the same problem. However, now that I put the code in, of course I can't save the document because I left the cells blank.

Is there any way I can save it with the cells blank, and next time I open the document to prompt me to the error if I try to save and certain cells are blank?