Hi
I'm trying to figure out how if I move the large blue rectangle "Rectangle 1" anywhere in the worksheet I can get the small red rectangle "Rectangle 2" to stay within it.
An example is attached
Using the top and left positions of the large rectangle will I need to set some sort of offset for the small rectangle?
Thanks
move.xlsm
Hello Stanley91,
You can Group the Shapes together...
- Press and Hold the CTRL key.
- Left Click each Shape you want in the Group.
- Release the CTRL key and Right Click.
- Select [b]Group{/b] from the popup menu.
- Select Group again from the Second popup.
Last edited by Leith Ross; 03-26-2014 at 01:08 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
In Drawing tools highlight both squares and use "Group"
Thanks
Sorry I should have specified is there a way of doing it without using group? the application I will be using the shapes for, grouping the shapes wont suit.
cheers
Last edited by Stanley91; 03-26-2014 at 01:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Stanley91 
Register To Reply
Bookmarks