Creating floor plan, duplicating shapes

[colinheslop1984]

I once used a document which I think was created on excel which was like a weekly planner but had shapes/icons listed in a key. You could drag and drop these icons in to the planner as much as you needed without it affecting the key.

I am wondering if anyone can shed some light on how this was done? If it was in fact done on excel.

I know I could just copy and paste icons I create, but would much prefer this technique.

 

[Yongle]

Here is a very simple macro so that you can see that it is easily possible within Excel
(could modify later eg to duplicate nominated shapes or give user option to choose backgound colour etc...)

Insert VBA in a new standard module like this ...
- go to VBA window with {ALT}{F11}
- Inset Module with {ALT} I M
- paste code below into that window
- close VBA window to go back to Excel

Sub Click_On_Shape()
    With ActiveSheet
        .Shapes(Application.Caller).Copy
        .Paste
    End With
End Sub

Test like this ...
- insert a shape \ Right-Click on it \ Assign Macro \ select Click_On_Shape \ OK
- right-click on the shape \ select Format Shape to modify it as you want
- click on any cell to deselect the shape
- left-click on the shape for duplicated shape
- drag new shape to another location
- insert other shapes and assign each one to macro Click_On_Shape