jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
I currently have in my JMayAddin File this code
That produces:
How can I eliminate the blank row BEFORE END SUB it is creating?
Thanks,
Jim
Code:
.....
With CodeMod
LineNum = .CreateEventProc("BeforeClose", "Workbook")
LineNum = LineNum + 1
.InsertLines LineNum, "Me.Saved = True"
End With
.....
That produces:
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub
How can I eliminate the blank row BEFORE END SUB it is creating?
Thanks,
Jim