• Strange .onaction behaviour

    Author
    Topic
    #460498

    When I refer to a shapes .onaction property, I expect to get the name of the macro I assigned to the shape. This may be to a macro in another workbook. This works fine in Excel 2003. However, in Excel 2007, when I refer to shape.onaction, I get “[0]!macroname” if the macro is in the activebook and “[1]!macroname” if the macro is in another book. Why do I get “[0]” or “[1]” instead of the path and workbook name in Excel 2007?

    regards
    Mark

    Reply To: Strange .onaction behaviour

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: