I can't seem to find the answer I need elsewhere, so here goes :) :

How can I create a macro that executes a message before file is close
(and before prompt to save changes) that warns a particular cell ha
not been changed/edited since opening the file - with option t
continue close and save changes OR cancel close and edit the cell?

This is basically because the file is a quote and the status of th
order must be updated every time the file is changed/opened; ie. Y or
must be entered in the cell to notify if it has been processed to a
order or not.

The warning serves the purpose that each time the file is opened t
check/edit details, this particular detail is not forgotten to b
updated, as our warehouse will check to see if they are awaiting a
order or not, so as not to have it arrive unexpected the next day!

Any ideas?
Many thanks
Ale

--
alex386
-----------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...fo&userid=3722
View this thread: http://www.excelforum.com/showthread.php?threadid=57038