Thread: How to programmatically access sheets in a workbook by code name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bing Bing is offline
external usenet poster
  
Posts: 48
Default How to programmatically access sheets in a workbook by code name
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?
Reply With QuoteReply With Quote