Sheet Codenames

[Annie Whitley]

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?

 

[Per Jessen]

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]

That did help thank you Per