on each sheet's code page you can add a property ...
right click the sheet tab & select code page...add
properties like this example:

Property Get S1() As String
S1 = "Sheet1 S1"
End Property

In a standard module, you can test the proprety:

Sub test()
MsgBox Sheet1.S1
End Sub


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi,

Can anybody help me in my requiremnt.

Let my Excel workbbok contains 2 worksheets sheet1 and
sheet2.
I want to add sheet specific custom property like say
sheet1 contains
custom property s1 and s2, and sheet2 have custom
property H1 and H2.

Is this possible??

If yes can anybody please direct me how to go ahead with
this.

This is urgent.
Thanks in advance.

Regards
Robin Patra
.