Change Excel Comment box Shape and make it Default

[Abhay Gadiya]

Hi,

I changed the shape of "Comment" box with edit shape. However when i right click the updated shape and click on Set Autoshape Default it does nothing. When I insert a new comment it is back to old shape.

Please tell me if this has to be done using any VBA?

 

[hippiehacker]

look at

Format Excel Comment Boxes using VBA Macros | Chandoo.org - Learn Microsoft Excel Online

 

[Abhay Gadiya]

Thank you for sharing the link...!