PDA

View Full Version : Add a row below an activebutton, keeping the format without resizing the button



guippezzini
06-01-2018, 04:54 PM
Hi. I would like to click at the "+" button and add an entire blank row below the "button", but keeping the format, fill color, and must not resize the button (when I insert a row manually, the button gets bigger to the cell below). I've searched the internet and didn't find a good macro.
The new row must not have the "+"button, or + sign.
Thanks!

22352

Hightree
06-02-2018, 03:37 AM
After insert a row, correct the size of the button I think

mana
06-02-2018, 05:44 AM
ActiveSheet.DrawingObjects.Placement = xlMove