Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code to add an event procedure to a worksheets code.
Rather than having to refer to the worksheet as "Sheet1", i would like to refer to the worksheet as its actual name, which is 10. How could I do so? Thanks in advance. See the following code where "SHEET1" is used. Sub addactivate() Dim StartLine As Long With ActiveWorkbook.VBProject.VBComponents("SHEET1").Co deModule StartLine = .CreateEventProc("Activate", "Worksheet") + 1 .InsertLines StartLine, _ "If lastAddress < """" Then Range(lastAddress).Select" End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT with an OR component | Excel Discussion (Misc queries) | |||
Office web component . | Excel Worksheet Functions | |||
Web Excel Component Bug | Excel Discussion (Misc queries) | |||
Changing VB Component Names to match Worksheet names using VBE | Excel Programming | |||
Chart component | Excel Programming |