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

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

Re: Formatting multiple sheets within workbook.

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Formatting multiple sheets within workbook.
Date 2017-03-31 07:08 -0400
Organization A noiseless patient Spider
Message-ID <obld65$9bo$1@dont-email.me> (permalink)
References (3 earlier) <obgkr7$739$1@dont-email.me> <obh9qb$l7e$1@dont-email.me> <f722d396-80cf-438a-8eb5-bbde006c810b@googlegroups.com> <obinl1$85j$1@dont-email.me> <097f2d1f-5726-4198-9db3-155ddf71f1b6@googlegroups.com>

Show all headers | View raw

> I must be doing something wrong with Garry's Cont sh Statement in that it is 
> either looking for the VB.name of the sheets, or the actual name on the 
> Sheet.tab

I use the sheet tab name in the list. The other name you refer to is the 
'CodeName'. Again, I recommend 'tagging' the process as a local scope defined 
name like "uiProcess" and set its RefersTo for the task to be acted on for the 
sheet[s]. You can also include multiple processes if need be o long as your 
business logic is well structured to manage this!

Note that both TabName and CodeName can be changed; -in the case of custom 
CodeNames Excel may reset those to default names unexpectedly.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

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

Thread

Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-28 03:40 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-28 03:42 -0700
  Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-28 10:56 -0400
    Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 03:40 -0700
      Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-29 11:48 -0400
        Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-29 17:46 -0400
          Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-30 03:25 -0700
            Re: Formatting multiple sheets within workbook. Claus Busch <claus_busch@t-online.de> - 2017-03-30 12:48 +0200
              Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-30 06:16 -0700
                Re: Formatting multiple sheets within workbook. Claus Busch <claus_busch@t-online.de> - 2017-03-30 15:48 +0200
              Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-30 11:10 -0400
                Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-31 04:03 -0700
                Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-31 07:13 -0400
              Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-31 03:51 -0700
                Re: Formatting multiple sheets within workbook. GS <gs@v.invalid> - 2017-03-31 07:08 -0400
    Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 03:52 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-03-29 02:43 -0700
  Re: Formatting multiple sheets within workbook. Living the Dream <noodnutt@gmail.com> - 2017-04-03 04:12 -0700

csiph-web