Hello all
I would like a very simple way to create shapes within multiple sheets with formatting.
Does anyone know of a way that i can very easily insert shapes into a cell on multiple sheets (around 50) - Sheets named 1 - 50.
For Example .. We have a list of buttons with Macro's assigned .. Button 1 creates Oval shapes, button 2 creates squares or rectangles etc
We would then have a second set of buttons which would then apply formatting / styling to those shapes EG: button 1 applies a Red fill to the shapes with a black border, button 2 applies a blue fill to the shapes with a black border and so on.
Would this be possible or does anyone know of a simpler way to achieve this?
Thanks
Dave
Bookmarks