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: Mon, 24 Jun 2019 07:49:01 -0500 From: FrancisM Newsgroups: microsoft.public.excel.programming Subject: Re: Using the red X (Upper right hand corner) for another purpose. Date: Mon, 24 Jun 2019 13:20:13 +0100 Message-ID: Organization: ExcelBanter.com User-Agent: X-Newsreader: X-Originating-IP: References: Lines: 11 X-Usenet-Provider: http://www.giganews.com X-Trace: sv3-77IeAIgbSCdpmjuLzo/rQ7KDbhihtrK2nkhVEBfnqW7Hq/+YZmsddRCD9x1FrUTwYlwTdPcl8oVCHBn!HvBqmvbSpQHfYlWnf9XRp4lUfZjBFFjZ2x7lHzS5O7KpE009TtZQCdtUB+7YWbHDeW1AtEeajSDb!gF4TtWFztg== 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: 2 X-Original-Bytes: 1425 Xref: csiph.com microsoft.public.excel.programming:110985 1 problem solved. I changed the code by adding "ThisWorkbook.Saved = True" after "Application.Quit". Now if I click on the exit button, both the workbook & the application close. Here are the remaining problems: 1) Msg box appearing 2X, 2) when the X is clicked, msg box appearing 2x, & workbook closing not application. -- FrancisM