Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assign Code to Shape (03; SP1)

    I have a worksheet from WB_01 that is copied to WB_02. The worksheet contains a "rectangle shape" which has code assigned to it. WB_02 has a module containing code which I would like to assign to the "rectangle shape" in WB_02. This is the same code which exists in WB_01. My challenge is that the "retangle shape" in WB_02 continues to reference the code in WB_01.

    I have tried using the following code but still encounter the reference to the other WB:

    ActiveSheet.Shapes("Rectangle 1").Select
    Selection.OnAction = "MyCode

    If I check to see how the code is assigned in WB_02 it references "WB_01.xls!MyCode"

    Your assistance is appreciated,
    John"

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assign Code to Shape (03; SP1)

    It took me a while but I finally found a <!post=resolution,122176 >resolution<!/post> posted by Andrew Cronnolly.

    Many thanks to Andrew,
    John

Posting Permissions

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