View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default Warning before saving files!

To get such a warning would require a macro. Here's a non-macro way.

Put this in a cell somewhere, formatted in a large red font. You can
copy/paste it from here.
=IF(AND(OR(NOT(ISBLANK(A2:B6))),OR(E1="",E2=""))," Name and Address
required","")

It's an array formula, so use Ctrl-Shift-Enter instead of Enter. Change the
A2:B6 to the cells where you'll be entering scores. Change E1 and E2 to the
cells for the name and address. If anything has been entered into A2:A6 and
either E1 and/or E2 are empty, it will declare "Name and address required"
loudly in red.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
oups.com...
OK - You guys were such a help with the last question. I have one more.

On the Excel worksheet (which is score sheet), I have two cells that
should have some information, like name and adress, that should be put
into them the 1st time I use the sheet. Sometimes I forget to do. Is
there a way that if I try to save the file without having put the
information into the cells, that Excel will warn me and tell me to
input the data before saving?

Thanks again.

24t42