Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110989
| Path | csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail |
|---|---|
| NNTP-Posting-Date | Tue, 25 Jun 2019 06:49:02 -0500 |
| From | FrancisM <FrancisM.1757bfa8@excelbanter.com> |
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Using the red X (Upper right hand corner) for another purpose. |
| Date | Tue, 25 Jun 2019 12:23:13 +0100 |
| Message-ID | <FrancisM.1757bfa8@excelbanter.com> (permalink) |
| Organization | ExcelBanter.com |
| User-Agent | |
| X-Newsreader | |
| X-Originating-IP | |
| References | <FrancisM.1752ea28@excelbanter.com> <qemo3m$cp9$1@dont-email.me> <FrancisM.17566e28@excelbanter.com> <FrancisM.17567c38@excelbanter.com> <qer2kp$507$1@dont-email.me> <FrancisM.1756dea8@excelbanter.com> <qerb2d$psq$1@dont-email.me> |
| Lines | 28 |
| X-Usenet-Provider | http://www.giganews.com |
| X-Trace | sv3-G8e6zkv+HORv0awqtNd4Iop+68X89qwYdLnX/a5iXn8CvHPnk8izym4UUe6cLzawl9Y3JEagJKoSsT9!mZpjwSCAXpNf0GxzCKyn8TQXTl3LEWmx3O8vDMFjGhLkPDH8EuN29PX/peVUW3iFV51bHEN3OwBN!nfTHBAo0pw== |
| X-Complaints-To | abuse@newsgroupbanter.com |
| X-Abuse-and-DMCA-Info | Please be sure to forward a copy of ALL headers |
| X-Abuse-and-DMCA-Info | Otherwise we will be unable to process your complaint properly |
| X-Postfilter | 1.3.40 |
| X-Original-Lines | 16 |
| X-Original-Bytes | 1943 |
| Xref | csiph.com microsoft.public.excel.programming:110989 |
Show key headers only | View raw
Thank You. I will provide a sample later today. I do have an update.
Yesterday, when I clicked on the x, it would not close both the workbook
& the application, Now it does. Ideally, when the x is clicked it takes
the user to the exit button but does not close. Also when the exit
button is clicked the message pops up twice. Here is a copy of the
current "Exit_Referrals" code:
Option Explicit
Sub Exit_Referrals()
Dim MsgBoxResult As String
If MsgBox("Would you like to Exit the Referral Workbook?" & vbCr,
vbYesNo, "Voc. Rehab. - Referral") = vbNo Then
Exit Sub
Else
Sheets("TOC").Select
Application.Calculation = xlCalculationAutomatic
ThisWorkbook.Save
Application.Quit
End If
End Sub
--
FrancisM
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.1752ea28@excelbanter.com> - 2019-06-21 19:57 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-22 22:28 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.17566e28@excelbanter.com> - 2019-06-24 12:48 +0100
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.17567c38@excelbanter.com> - 2019-06-24 13:20 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-24 13:52 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.1756dea8@excelbanter.com> - 2019-06-24 20:08 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-24 16:16 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.1757bfa8@excelbanter.com> - 2019-06-25 12:23 +0100
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.1757f7e8@excelbanter.com> - 2019-06-25 15:54 +0100
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.17596589@excelbanter.com> - 2019-06-26 18:32 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-26 16:36 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.175a62a8@excelbanter.com> - 2019-06-27 12:07 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-27 12:37 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.175ab708@excelbanter.com> - 2019-06-27 17:59 +0100
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.175bb428@excelbanter.com> - 2019-06-28 12:32 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-28 12:16 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.175c0888@excelbanter.com> - 2019-06-28 18:28 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-28 15:00 -0400
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-06-28 15:30 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.175fa8a8@excelbanter.com> - 2019-07-01 12:07 +0100
Re: Using the red X (Upper right hand corner) for another purpose. GS <gs@v.invalid> - 2019-07-01 08:09 -0400
Re: Using the red X (Upper right hand corner) for another purpose. FrancisM <FrancisM.17614078@excelbanter.com> - 2019-07-02 17:26 +0100
csiph-web