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