Validation won't do it.

You need VBA event code.

See Chip Pearson's site for event code instructions specificaly
worksheet_deactivate and workbook_beforesave

http://www.cpearson.com/excel/events.htm

And David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/event.htm


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 10:22:08 -0600, caliskier
wrote:


I am looking at validation to see if I can make a error message pop up
only when the user clicks a different sheet or attempts to save as I
don’t want to annoy people with having to constantly click on message
boxes. Is this possible?