View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vinit[_2_] Vinit[_2_] is offline
external usenet poster
 
Posts: 18
Default How to uniquely identify worksheet

Hi friends,

I want to uniquely identify the worksheets in my workbook. I am writing
an add in using VC++. I cant access "CodeName" property of worksheet
using VC++ bcoz it always return blank. The problem in using "Name"
of worksheet is that user can change it any time. There is no event in
excel to keep track of the name change of worksheet. Even I cant use
Worksheets(Index) b'coz sequence can be changed.

Please help me to solve this.

With Best Wishes & Regards,