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