Locks pictures and radio buttons to cells

Hello,
I want to locks pictures and radio buttons to the cells so that when I hide
rows, the picture or radio buttons also hide. I prefer if these can be done
without VBA, or VBA if it is better to use.


Thanks

Hi Rocky2013

To hide your pictures when you hide the Column that contains them:

• Right Click on the Picture
• Select Size and Properties
• Select Properties
• Select Move and Size with Cells

Hiding the Option Buttons when you hide the Column that contains them is a bit more tedious. You can follow the same process as described above but you'll see that "Move and Size with Cells" is grayed out and you can't select it.

There's a workaround described here
http://www.mrexcel.com/forum/excel-q...ize-cells.html

Here are the steps I successfully took:

• In my Quick Access Toolbar I have added "Select Multiple Objects"
• Click on that Icon
• Select all of your Option Buttons
• Right Click on the Option Buttons
• Select Grouping
• Select Group

Now repeat the process

• Click on the "Select Multiple Objects" Icon
• Select the Group of your Option Buttons
• Right Click on the Option Buttons
• Select Grouping
• Select Ungroup

The Option Buttons should now be set to "Move and Size with Cells"

Worked for me...don't know why.

Glad you got it working...