Team,
When I add a new worksheet, I must also copy to that sheet a command button. Next I need to add some code to the sheet's VBE object. And need some help here.
I've added the code to a string variable
I've already changed the sheet's name. But I don't know what the sheet's "codename" is. So I need to address the VBE Object by the sheets' tab name.
Any Ideas??
John,
In Annapolis.
When I add a new worksheet, I must also copy to that sheet a command button. Next I need to add some code to the sheet's VBE object. And need some help here.
I've added the code to a string variable
Code:
sString = "Private Sub cboInsertText_Click()" & vbcrlf & _
"Call InsertText" & vbcrlf & _
"Sub End"
I've already changed the sheet's name. But I don't know what the sheet's "codename" is. So I need to address the VBE Object by the sheets' tab name.
Any Ideas??
John,
In Annapolis.
Last edited: