You're gonna hate me... How do I define exactly which fields need filling in
before the doc can be saved? I have never seen anything like that formula. I
am new to all this (though I guess that's pretty clear!)

Thanks for your help though.

Rob,
Teesside,
UK

"Jason Morin" wrote:

Press ALT+F11, and double-click on the "ThisWorkbook"
module underneath your workbook. It'll look like "VBA
Project..." Paste in all the code. Press ALT+Q to return
to Excel.

-----Original Message-----
I don't understand the instructions! Sorry to bother
you. Can you help?

"Jason Morin" wrote:

J.E. McGimpsey posted some code to do just what you're
asking:

http://tinyurl.com/3kaos

HTH
Jason
Atlanta, GA

-----Original Message-----
I am creating an application form to be used
electronically. I want to make
sure that users fill in certain fields (cells). How
can
I make Excel tell the
user that when they click on 'close', they can not
close
or save the file
until all fields are populated? This is driving me
mad!!!!
.


.