Adding Custom Property

[Robin Patra]

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

 

[Patrick Molloy]

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

 

[Bob Phillips]

Custom properties are a workbook property. You could use a naming convention
that pertains to a sheet, but sheers get renamed.

There is another property, worksheet names, that are at the sheet level.
Maybe you could use that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)