I've been forwarded a piece of code to troubleshoot but am getting no-where fast! It appears that when a shape (triangle, star etc) is inserted on a worksheet in Excel 2007, the shape is then selected, the below code throws an Runtime 1004 error and does not allow the dialog box to open:
This is not the case when selecting a basic rectangle or square in the same way. If the code is run outside of the shape it works as expected.
Can anyone enlighten me on why this seems to work for some shapes but not others?
Many thanks in advance.