On Fri, 9 Sep 2005 12:58:42 -0500, chanwando
wrote:
Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh
Any help would be appreciated!
Thanks so much!
Chandra
Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|