Avatar
Board Regular
- Joined
- Sep 20, 2005
- Messages
- 193
Greetings,
I've run into a small problem with shapes..
Overview:
I have an excel workbook that copies rows from one sheet to put into another sheet. The originating rows have 1 shape attached. On click of this shape, i want to to identify the row it is on, and delete it.
The Problem:
I've found no way to identify the row the shape is on, or even the name of the shape. On click of the shape, it runs a macro. Since the image can be replicated 50 or more times, i have linked the original to 1 macro, which means all subsiquent copies of the shape, calls the same macro - hense the need to identify the row.
What i want, is to be able to identify the row that the shape is on, so i can identify which row to delete.
Any ideas??
I've run into a small problem with shapes..
Overview:
I have an excel workbook that copies rows from one sheet to put into another sheet. The originating rows have 1 shape attached. On click of this shape, i want to to identify the row it is on, and delete it.
The Problem:
I've found no way to identify the row the shape is on, or even the name of the shape. On click of the shape, it runs a macro. Since the image can be replicated 50 or more times, i have linked the original to 1 macro, which means all subsiquent copies of the shape, calls the same macro - hense the need to identify the row.
What i want, is to be able to identify the row that the shape is on, so i can identify which row to delete.
Any ideas??