Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110991

Re: Using the red X (Upper right hand corner) for another purpose.

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!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date Wed, 26 Jun 2019 12:49:01 -0500
From FrancisM <FrancisM.17596589@excelbanter.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Using the red X (Upper right hand corner) for another purpose.
Date Wed, 26 Jun 2019 18:32:02 +0100
Message-ID <FrancisM.17596589@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> <FrancisM.1757bfa8@excelbanter.com> <FrancisM.1757f7e8@excelbanter.com>
Lines 22
X-Usenet-Provider http://www.giganews.com
X-Trace sv3-Rh2HK7b/j3/FBllNtAQyTfTFN9o7bK9xhGwFRuAEOGn8lG9BhZJcR8O3CBNyyPM5rpC7xzVzWIJWMXf!NbOISIIh59iO/F393wb3VaY5KxtCYVrSc5m5ZLnBiWJRNEDysQPW2NEyXJRrPKuI5qh59EKB1kmB!apONYL1xLw==
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 7
X-Original-Bytes 2119
Xref csiph.com microsoft.public.excel.programming:110991

Show key headers only | View raw

Ok. I have gone from 4 problems to 1. Here is what currently happening.

When the application X is checked; a msgbox pops up instructing the user
to "Click Exit to Close."  When  "Ok" or the X is checked on the msgbox,
it disappears; That is what I want. 
When the "Exit" button is checked, the following error message
appears: "Compile error: Statements and labels invalid between Select
Case and first case".  It hangs  on this line: "ThisWorkbook.fMacro =
True" & on ".fMacro = True" in particular. 

Please tell me why it is hanging on the line located in module 1 only &
not on the line located in Thisworkbook.  I commented out the 2 lines
(fmacro), so I could close the file. If I did not post the link to the
sample correctly, please let me know. 

If you have other suggestions, please let me know.




-- 
FrancisM

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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