View Single Post
  #2   Report Post  
Richard Buttrey
 
Posts: n/a
Default

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
__________________________