Selecting All Buttons

**jonn** · 04-28-2007, 02:30 PM

Hi,

Is there a way from VBA of selecting all the button on a sheet then deleting them? at the moment i'm selecting and deleting them all seperately. is there a quick way?

Thanks

**Simon Lloyd** · 04-28-2007, 03:13 PM

If you're deleting the same buttons every time why not record a macro?, start the recorder and select the buttons as an array by holdng down Ctrl when you click each button, go to your recorded macro and and it will look something like this:

Please Login or Register  to view this content.

then add some code to delete them like:

Please Login or Register  to view this content.

if the code doesn't work the way to do it by hand is to select them as a group (array) as explained above and then choose cut!

**jonn** · 04-28-2007, 03:34 PM

hi,

I've been using the array method but I think I didn't explain myself very well, can all the button be selected without defining there names? the reason i ask is i am copying sheets to new a workbook, where in excel 2000 and excel 2007 give the button different names, so selecting button names then delete works for one version and not the other.

Thanks

**mudraker** · 04-28-2007, 08:32 PM

jonn

depending on if you have other objects on the sheet you could use

Please Login or Register  to view this content.

**mikerickson** · 04-28-2007, 09:17 PM

This worked for me. The above code will remove all shapes not just the buttons.

Please Login or Register  to view this content.

Selecting All Buttons

LinkBack

Thread Tools

Rate This Thread

Display

Selecting All Buttons

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions