Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Worksheet change procedure
I get a runtime error in Excel using the following method:
Sub AddEvents() Dim vbc As VBComponent, pos As Long, body as String For Each vbc In ActiveWorkbook.VBProject.VBComponents If vbc.name = Worksheets(1).codeName Then pos = vbc.CodeModule.CreateEventProc("Change", "Worksheet") body = wsEvent vbc.CodeModule.InsertLines pos, body Exit For End If Next End Sub What am i doing wrong? Any help appreciated ojv |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Worksheet change procedure | Excel Programming | |||
Run procedure from worksheet change event | Excel Programming | |||
Validation Procedure with a worksheet change event | Excel Worksheet Functions | |||
Excel locks with Worksheet Change procedure | Excel Programming | |||
Worksheet change sub procedure | Excel Programming |