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

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

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!buffer2.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date Fri, 28 Jun 2019 12:49:03 -0500
From FrancisM <FrancisM.175c0888@excelbanter.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Using the red X (Upper right hand corner) for another purpose.
Date Fri, 28 Jun 2019 18:28:53 +0100
Message-ID <FrancisM.175c0888@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> <FrancisM.17596589@excelbanter.com> <FrancisM.175ab708@excelbanter.com> <FrancisM.175bb428@excelbanter.com> <qf5ega$4j2$1@dont-email.me>
Lines 20
X-Usenet-Provider http://www.giganews.com
X-Trace sv3-QOkzINnYaV7RcmPM/oy4CW8dpLAuFAHwmSP93sxUrT58stPiWbN3uZr5bdryukMdFWx9zYgZEfal+pI!kq0zd8Nq5QrL4LjGQGyC1MncJy2JTuq6CgjhXBRqabsXgTpiNzMYmclGBGwAO/gKdKJlPpDDi9D2!Sf/86qUJ+w==
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 1
X-Original-Bytes 2100
Xref csiph.com microsoft.public.excel.programming:110998

Show key headers only | View raw

Thanks for explaining about my global var. I did indeed move it to
Module 1. I assume that it should be placed right below "Option
Explicit".  
The workbook has 68 sheets. Some of the sheets have (Dropdowns)
that refer to 3 others. 5 sheets are used for reports. 1 is a table of
contents, the other sheets are basic data entry.  This workbook is one
where my supervisor asked me to combine multiple workbooks into one. 
She has used these workbooks for several years, I am kind of stuck with
the layout. 

What I don't understand is, it looking for  when I use 
"ThisWorkbook.fMacro = True"

I am not familiar with this site, can you upload sample, in a PM?




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