Deleting Macro Buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
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?
 
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
Click to expand...
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?
 
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
Click to expand...
progress in over an hour. Is there a way to 'select all' for these buttons and delete all at once?
 
Back
Top