Hello!
I currently have the code below to insert a macro button and assign a macro to the button. This code works perfectly. However, the placement of the button needs to be dynamic. In the tab, I have a pivot table that will vary with columns each time I run a particular procedure. After the Pivot table is created, then there are two macro buttons that are inserted in a specific spot. However, I need the buttons to be inserted just to the right of the last column in the pivot table. I would like the Macro buttons to stay in the same "height" but change where it is placed, which is just to the right of the last column in the pivot table. Please see my code below:
Please Login or Register to view this content.
Bookmarks