PDA

View Full Version : Pictures - Grouping and Flip



tpsantu
07-02-2013, 01:40 AM
Hi Friends,

I have a tricky automation necessary. In a worksheet, I have several pictures with different annotations (rectangles, callouts, circles etc.) marked on them. My requirement is,

1. Group a picture and all its related annotations
2. Flip horizontally the above created group

In this way, I have several pictures in multiple worksheets - the idea is to write a macro which can group and flip all the pictures in the workbook. However issues I am facing are

1. How do I link a picture and only ITS annotations (rectangles or callouts) for grouping?
2. Some of the pictures are like legends - these need not be flipped - can I sort them out based on shape height and exclude them from the loop?

I have an idea how to get the list of names/ID's of all the pictures in the workbook, however that isn’t helping me much because looking at the list doesn’t give me an idea which rectangle annotation belongs to which picture.

Attached is an example file
1. The first picture and its rectangles are to be grouped and flipped
2. The second picture and its circles are to be grouped and flipped

Please help me in this - its going to save LOADS of time at my workplace. Thanks in advance