this code is written to update the shape of the color whenever i drag n drop it according to its position. it is called once in workbook_open() event
But it is running all the time from opening the workbook till closing it.
Is there any method to make it run only when shape is selected.

Please Login or Register  to view this content.