I have a worksheet where I’m attempting to do a couple of things –
- Use checkboxes to allow the user to choose varying styles of phones to configure. When they check a box, this will unhide rows within the worksheet specific to the selection they made. This functionality is in row 5 of the attached and is working.
- When the checkbox is unchecked I need it to hide the rows (this works) along with the command button within that row (this is not working). If I group the command button with the picture, then it will hide/unhide with the row, but the functionality of the command button stops working. Is there a way to hide the command button when the corresponding checkbox is unchecked?
- When a user selects the command button, they are prompted to enter a numerical QTY and based on that QTY, copy cells E10:I24 and paste it as many times as the QTY they entered - starting in cell K10. On the attached, you can see how it should look if the user entered 4. This part I can’t figure out – the code I used was from another worksheet that had similar functionality - but row based. This needs to be column based and row dependent on the various items..
Thanks for any help/guidance