Consulting

Results 1 to 3 of 3

Thread: Add a row below an activebutton, keeping the format without resizing the button

  1. #1

    Add a row below an activebutton, keeping the format without resizing the button

    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!

    EXCEL DUVIDA.jpg

  2. #2
    VBAX Regular
    Joined
    Jan 2018
    Location
    The Netherlands
    Posts
    45
    Location
    After insert a row, correct the size of the button I think

  3. #3
    VBAX Expert
    Joined
    Sep 2016
    Posts
    788
    Location
    ActiveSheet.DrawingObjects.Placement = xlMove

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •