Inserting a shape on many sheets and assigning a macros to the shape.

[hegdep]

Is there a way to insert a shape on the same location on many sheets and call a macros when this button is clicked? At one shot, I mean.

[humdingaling]

Yes
something like this

Please Login or Register  to view this content.

[hegdep]

Thanks a ton!
One additional question. How do I position this shape correctly? Say, I want it between T3 and U4 in every sheet?
Also,if I want some Text over it, would ActiveShape.Text = "Something" work?

Also, what if I want to select a shape style?

[humdingaling]

Please Login or Register  to view this content.

how exactly do you want to select the shape?

here's a list of shapes you can use
https://msdn.microsoft.com/VBA/Offic...eration-office

[hegdep]

Thanks!
I am referring to no other shape. Just applying a preset style(this is unique to each version of office, I presume)
From the macros recording I tried out to do the same msoShapeStylePreset37

Please Login or Register  to view this content.

Logically, this should work.

I'll try it out and let you know. Thanks a ton for your help!

[humdingaling]

yeah there is a list of presets
https://msdn.microsoft.com/en-us/lib...tyleindex.aspx

descriptions of what they are wont help you much
you are much better off just doing what you are doing, record macro to find the preset number