Im trying to make a exceldokument with vba where i have a certain area on sheet1 that is printable, i would like to make some buttons in a meny with 10 different options to insert rows/table to the printable area. And ofcourse also to remove from the area. So the deal is that i would like to have for example button1 to include 4x2 table with name table1. next button should be button2 and insert 4x16 table underneith the first table. and it should be automatic choosing the first free row +1.
this is a document where i can make some hardware setup, first to choose the hardware from the buttons, and when i put in the hardware i will customize the tables in the printable area with information. This is so it will be easy for the user to choose correct hardware from a pre set list of hardware. I dont also know how to make a remove button for each inserted table easy. so for example i insert 20 hardware config to the printable area and then i change my mind about nr 15 and wanna remove it/change it.