Deleting Macro Buttons

J

Jpequeno

I have a spreadsheet with thousands of macro buttons that are on top of each other. I've cut these one by one and have made little progress in over an hour. Is there a way to 'select all' for these buttons and delete all at once?
 
D

DDM

Jpequeno, select one button, then Ctrl+Shift+Spacebar to select them all.
Then Delete.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


Jpequeno said:
I have a spreadsheet with thousands of macro buttons that are on top of
each other. I've cut these one by one and have made little progress in over
an hour. Is there a way to 'select all' for these buttons and delete all at
once?
 
D

Dave R.

Press F5, select OBJECTS, and that will select them all. Then press your
'Delete' key.


Jpequeno said:
I have a spreadsheet with thousands of macro buttons that are on top of
each other. I've cut these one by one and have made little progress in over
an hour. Is there a way to 'select all' for these buttons and delete all at
once?
 
R

Ron de Bruin

Try this

This will delete all objects

F5
Special
select objects
OK
press the delete button on your keyboard

--
Regards Ron de Bruin
http://www.rondebruin.nl


Jpequeno said:
I have a spreadsheet with thousands of macro buttons that are on top of each other. I've cut these one by one and have made little
progress in over an hour. Is there a way to 'select all' for these buttons and delete all at once?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top