Resize buttons to cell

[bioman_1]

Hi All,

I've got a couple of sheets with a lot of buttons in them. Some of these buttons have the wrong dimensions. What I want to do is run a macro so that every button gets the same dimensions as a given cell. I've found the following macro:

Please Login or Register  to view this content.

But this doesn't do anything (no error, but also no changes). If I step through the macro it jumps from line "For Each obj In ActiveSheet.OLEObjects" to line "Exit Sub". So it seems there are no OLEObjects in the sheet. But there are about 100 buttons in the sheet.

Could a button be anything else than an OLEObject? And if so, is there a way I can change this macro to do what I want it to do?

[romperstomper]

If you used Forms buttons, then they are Buttons rather than OLEObjects:

Please Login or Register  to view this content.

[bioman_1]

That did the trick. Much appreciated!

[dkindred]

@ romperstomper, Had been googling for about an hour b4 i came across you post!!

Fixed my problem which was very close to OP's.

trouble i had was Excel 2010 resizes form buttons after auto-filtering.

Thank you.