Clickable button in excel

[2_nisia]

Hello,

I have added some clickable buttons in few cells, but when I try to hide a row, the button still remains.
Is it possible for the button to be hidden together with the row?

I thought that might be the solution but I cant even choose the first one.


Also, is it possible to make the buttons bigger?

Thanks in advance!

 

[Anthony47]

That looks a CheckBox from the "Module" toolset, not a Button
If you need using a checkbox, then pick it from the ActiveX toolset, as it allows the first option (Move and Size with the cell)
Or use a real "Button"

 

[2_nisia]

I used the 3rd option from the Form Controls. Is that what you refer to as "Module" toolset?

The activex runs a macro, and it will complicate even more my code. But I will just try to remove the checkbox option if there is no other way

 

[Anthony47]

What I called "Modules" are the Form Controls
Yes, ActiveX are a little bit more complex, but they have the option you need