Okay ... so I posted a thread a while ago about vertically flipping a shape in Excel when clicked, then returning the row number in which the shape is located. Solved that problem in Excel 2003 pretty quickly using the following code:
ActiveSheet.Shapes(Application.Caller).Flip msoFlipVertical
sRow = ActiveSheet.Shapes(Application.Caller).TopLeftCell.Row
Works great in Excel '03 ... but falls flat on its face in Excel '07. Application.Caller is returning the first shape in the workbook regardless of which shape is clicked. Any ideas what's happening here or a workaround?
Cheers =)
Bookmarks