How to programmatically access sheets in a workbook by code name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Again

I want to be able to refer to worksheets in a workbook programmatically that
way i wont have to worry if endusers will change the name of the worksheet.

Right now i'm using : ThisWorkbook.Worksheets("Sheet"1), but if i "Sheet1"
has a code name of 'secret', how can i go about getting a Worksheet reference
using that code name?
 
dim s as worksheet
set s=secret

Or (better) just use "secret" directly as in:

secret.Activate

Tim.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to reference a cell from anther workbook without opening it 0
Reference sheets named by DAY 7
Copying cells and formula from closed workbook to all sheets in open workbook 0
Delete sheets code error requires object 2
Save As and new workbook new name used in existing code 8
Problem in adding macro to ribbon through Add-in 7
Reference a workbook level named variable. 8
Displaying all Named Ranges in workbook 4

Back
Top