Adding VB code to worksheet programatically
 

I have an Excel VB program which creates new worksheets from other Excel
worksheets. But, I would like to programatically add VB code to the newly
created worksheet such that when I double click on one of the cells in the
created worksheet I have specific VB code run that does some additional
processing.

What I do now is each time I run my VB code, which creates the new
worksheets, I have to go to each new sheet and add a procedure line to the
worksheet. See below:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
MyTest
End Sub

Would like some code to add the "MyTest" code to the new worksheet without
me having to add it manually.

The MyTest proc allready exists and works.

How do I do this?

Adding VB code to worksheet programatically
 

See www.cpearson.com/excel/vbe.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"seegerp" wrote in message
...
I have an Excel VB program which creates new worksheets from
other Excel
worksheets. But, I would like to programatically add VB code to
the newly
created worksheet such that when I double click on one of the
cells in the
created worksheet I have specific VB code run that does some
additional
processing.

What I do now is each time I run my VB code, which creates the
new
worksheets, I have to go to each new sheet and add a procedure
line to the
worksheet. See below:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range,
Cancel As
Boolean)
MyTest
End Sub

Would like some code to add the "MyTest" code to the new
worksheet without
me having to add it manually.

The MyTest proc allready exists and works.

How do I do this?

Adding VB code to worksheet programatically
 

U¿ytkownik "seegerp" napisa³ w
wiadomo¶ci ...
I have an Excel VB program which creates new worksheets from other Excel
worksheets. But, I would like to programatically add VB code to the newly
created worksheet such that when I double click on one of the cells in
the
created worksheet I have specific VB code run that does some additional
processing.

What I do now is each time I run my VB code, which creates the new
worksheets, I have to go to each new sheet and add a procedure line to the
worksheet. See below:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
MyTest
End Sub

Would like some code to add the "MyTest" code to the new worksheet without
me having to add it manually.

The MyTest proc allready exists and works.

How do I do this?

you should find it there
http://www.cpearson.com/excel/vbe.htm
mcg