I need to determine which shape has been clicked to get the column of this shape.
So I have multiple shapes in a worksheet and they all have the same name... (Automated generation) but they are in different culumns.
Each shape has the same sub associated to his .Onaction which is a simple .show sub
Then at Userform_Initialize() I need to know which one has been clicked on.Please Login or Register to view this content.
The problems is:
- They all have the same name so this get the first named as the one clicked on in the shapeS collection
And the sheet must remains locked... So no selection...Please Login or Register to view this content.
Any ideas?
Bookmarks