Press the Alt-F11 key combination to open the VBA editor.
Press Ctrl-R to open the Project Explorer on the left
Double-click the This Workbook node for the workbook in question
Paste in this code



Private Sub Workbook_BeforeClose(Cancel As Boolean)

If MsgBox("Is all your input correct?", vbYesNo, "Confirm") = vbNo Then _
Cancel = True

End Sub



"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


--
chanwando
------------------------------------------------------------------------
chanwando's Profile: http://www.excelforum.com/member.php...o&userid=27123
View this thread: http://www.excelforum.com/showthread...hreadid=466339