Consulting

Results 1 to 3 of 3

Thread: Adding code to a worksheet on the fly

  1. #1
    VBAX Contributor
    Joined
    Apr 2006
    Posts
    100
    Location

    Adding code to a worksheet on the fly

    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?

    [VBA]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[/VBA]

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    No.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    ...answered

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •