NEED HELP with linking MACROS BUTTONS to CELLS

[dset64]

I am doing a spreadsheet and I was hoping to link Macros buttons to different cells. I don't want to link it according to matching similar looks or via formulas, just displays. So that the "text box" or "button" will always display inside that cell no matter what. Even if the cell is resized it will match the size of the cell and will always display in it. Can this be done?

Thank you for your time

 

[tigeravatar]

Right-click the object (button, textbox, etc) -> Format Control -> Properties -> Select "Move and resize with cells" -> OK

 

[dset64]

Is there a way to mark which cell you want to link the button to? As of now I placed each button with those settings in different cells and it's not working

 

[tigeravatar]

I'm afraid you've lost me. What are you trying to do?

 

[dset64]

I dropboxed a picture of a screenshot of the document. If you look at the left screen the "YES" and "NO" macros buttons are not the same size as the cells they are in. Do you know how to fix this?

https://www.dropbox.com/sh/rb0n1as21r59er0/kBufnFJpCI

 

[pboltonchina]

Insert a Form Control button and make it exactly the same size as your cell and assign the macro. When you resize the row or column the button changes as well

 

[dset64]

Thanks that's very helpful, I think I have it now!