Worksheet names vs Code names

There are two different worksheet names you need to know.

In this lesson we learn:

• What is the difference between public name vs Code name
• How to find and change each name (using the VBA Editor – Properties window)
• How to activate worksheets using the public name vs Code name
• The importance of watching out when you change the public name… but don’t change your code to match (you get an error)

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]