Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Custom Property
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Custom Property
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Custom Property
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) "Robin Patra" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
File/custom Property fields | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
"See" Custom Property | New Users to Excel | |||
Adding Custom OCX to Excel in Add In | Excel Programming |