PDA

View Full Version : Adding code to a worksheet on the fly



SeanJ
05-14-2010, 03:02 AM
is there a way to add code on the fly from excuting code to a worksheet without having "trusted access to the vba project object model" to be turned on? :banghead:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$104" Then
Call TgrphSzedown
ElseIf Target.Address = "$A$105" Then
Call TgrphSzeUp
ElseIf Target.Address = "$A$106" Then
Call reset_graph
End If
End Sub

Bob Phillips
05-14-2010, 03:17 AM
No.

GTO
05-14-2010, 03:18 AM
...answered