Don't know what to call what I need?

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

On Fri, 9 Sep 2005 12:58:42 -0500, chanwando
<chanwando.1v3smf_1126289146.3826@excelforum-nospam.com> 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
__________________________

"Richard Buttrey" wrote:

> On Fri, 9 Sep 2005 12:58:42 -0500, chanwando
> <chanwando.1v3smf_1126289146.3826@excelforum-nospam.com> 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
> __________________________
>

Based on the posters subject line: Don't know what to call what I need?, and
on the wording of their post, what are the chances of them knowing what this
means:

> Use the Workbooks "BeforeClose" event and stick a Message box in the
> Workbook_BeforeClose procedure

Something to think about. And no, I don't know how to do it.

right click sheet tab>view code>left box select worksheet>right box select
deactivate>put in your code.

--
Don Guillett
SalesAid Software
donaldb@281.com
"chanwando" <chanwando.1v3smf_1126289146.3826@excelforum-nospam.com> wrote
in message news:chanwando.1v3smf_1126289146.3826@excelforum-nospam.com...
>
> 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
>

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
>
>

I really appreciate the help and suggestions!

Duke Carey - I'm sorry that you had to do my work for me, but you did it GREAT!!! It did exactly what I needed it to and now I have a happy boss.....

(...and you're right "Lookin", I have virtually NO experience with VB...just Excel.)

Thanks again for all the help and I even learned something new out of the deal!

Chandra