Post what you've tried so far. It maybe easier to correct that way.

abfabrob wrote:

I haven't got a clue. It brings up the message "Compile error: User-defined
type not defined" This may as well be in Hebrew!

But thanks again for the help,

Rob.

"Jason Morin" wrote:

Where it reads:

Sheets("Sheet1").Range("A1, B2")

in the macro, change the sheet name and cell references
to what it needs to be. You can add more cell references,
just make sure to include commas. For example,

..Range("A1,B2,C4,G17,P100")

Jason
-----Original Message-----
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!!!!
.


.


.



--

Dave Peterson