Hi everyone,

I've got a workbook in which other users may rename sheets so I want to 
change all tab names to codenames in VBA modules.

I've read that I can do it using Find/Replace in the VBE but what I wanted 
to know is whether I need to tell it I'm using the codename for sheets.

If I have to (or should) how would I do it?
-- 
Thank you
Annie

Hi Annie

With a worksheet level sheet name the syntax is:

Worksheets("Sheet1").Select

With a VBA level code names the syntas is:

Sheet1.Select

Hopes this helps.
....
Per

"Annie Whitley" <AnnieWhitley@discussions.microsoft.com> skrev i meddelelsen 
news:EBB5464D-A04F-4170-BDDD-BF637A25157B@microsoft.com...
> Hi everyone,
>
> I've got a workbook in which other users may rename sheets so I want to
> change all tab names to codenames in VBA modules.
>
> I've read that I can do it using Find/Replace in the VBE but what I wanted
> to know is whether I need to tell it I'm using the codename for sheets.
>
> If I have to (or should) how would I do it?
> -- 
> Thank you
> Annie 

That did help thank you Per :-)
-- 
Thank you
Annie


"Per Jessen" wrote:

> Hi Annie
> 
> With a worksheet level sheet name the syntax is:
> 
> Worksheets("Sheet1").Select
> 
> With a VBA level code names the syntas is:
> 
> Sheet1.Select
> 
> Hopes this helps.
> ....
> Per
> 
> "Annie Whitley" <AnnieWhitley@discussions.microsoft.com> skrev i meddelelsen 
> news:EBB5464D-A04F-4170-BDDD-BF637A25157B@microsoft.com...
> > Hi everyone,
> >
> > I've got a workbook in which other users may rename sheets so I want to
> > change all tab names to codenames in VBA modules.
> >
> > I've read that I can do it using Find/Replace in the VBE but what I wanted
> > to know is whether I need to tell it I'm using the codename for sheets.
> >
> > If I have to (or should) how would I do it?
> > -- 
> > Thank you
> > Annie 
> 
> .
>