Sheet Codenames

  • Thread starter Thread starter Annie Whitley
  • Start date Start date
A

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?
 
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
 
Back
Top