Hi there,
After the
VB lines of code (ran in Excel)
Bla bla bla
'/*/*/*/*/*/*/*/*/*/*/*/*/
'Insert a proc into Sheet1
'/*/*/*/*/*/*/*/*/*/*/*/*/
Dim Startline As Long
With ActiveWorkbook.VBProject.VBComponents("Sheet1").Co deModule
Startline = .CreateEventProc("Change", "Worksheet") + 2
..InsertLines Startline, "call Update_residuals"
End With
End If
retest = False
Workbooks(glbMainTrialFileName & ".xls").Save
Unload Me
Exit Sub
the
VB editor opens by magic ?
could anybody tell me why ?
Dallag
--
dallag
------------------------------------------------------------------------
dallag's Profile:
http://www.excelforum.com/member.php...o&userid=29762
View this thread:
http://www.excelforum.com/showthread...hreadid=494813