How to Delete Extra Macro Buttons from an Excel Worksheet
Question details
The user needs to remove unused macro buttons, form controls, or shapes from an Excel worksheet without triggering the macros assigned to them.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Cleaning up a spreadsheet by deleting unwanted interactive elements like form buttons or drawn shapes that were previously created via the Developer tab or Shapes menu.
- Observed behavior
- Extra macro buttons remain on the worksheet, and clicking them normally triggers the macro instead of allowing the user to select and delete them.
Ensure that your worksheet is not protected. If sheet protection is enabled, you may be blocked from selecting or deleting objects like shapes and macro buttons.
Use the Select Objects Tool
This is the most reliable method to select and delete interactive buttons or shapes without accidentally running their assigned macros.
The Select Objects tool changes your cursor into an arrow that only selects objects on the spreadsheet, ignoring the cells underneath. This is especially helpful if you need to bulk-delete multiple form controls or if you have difficulty clicking a specific button.
Navigate to the 'Home' tab on the Excel ribbon. In the Editing group on the far right, click on 'Find & Select'.
From the drop-down menu, choose 'Select Objects'. Your cursor will change to a standard pointer.
Click the unwanted macro button to select it. To select multiple buttons at once, either hold down the 'Shift' key while clicking them individually, or click and drag a rectangle around the group of buttons.
Press the 'Delete' key on your keyboard to remove the selected objects. Once finished, click 'Select Objects' again from the Find & Select menu to turn it off and return to normal cell editing.
Delete the Underlying Rows
A practical workaround if you prefer not to use the Select Objects tool or want to quickly clear out a specific section of the worksheet.
Easily Remove Unwanted Objects with WPS Spreadsheet
WPS Office offers a powerful, user-friendly Spreadsheet application that allows you to easily manage form controls, macros, and shapes with intuitive tools.
- 1. Open Your File: Launch WPS Office and open your spreadsheet containing the unwanted macro buttons.
- 2. Use Find and Replace: Go to the 'Home' tab, locate the 'Find and Replace' icon on the right side of the toolbar, and click it.
- 3. Select Objects: Choose 'Select Objects' from the dropdown list. Click on the macro buttons you wish to remove, then press 'Delete' on your keyboard.
Frequently Asked Questions
Why can't I select the macro button to delete it?
Clicking a macro button with the left mouse button usually runs the assigned macro instead of selecting the object. To select it for editing or deletion, you must either right-click the button or use the 'Select Objects' tool found under the Home tab.
Will deleting the macro button also remove the underlying VBA code?
No, removing the button only deletes the visual shape or form control from the worksheet. The actual VBA macro code remains stored in your workbook. To completely remove the code, you need to open the Developer tab, select Visual Basic, and delete the code from the corresponding module.
What should I do if the 'Select Objects' tool is grayed out?
This typically occurs if the worksheet is protected. Navigate to the Review tab and click 'Unprotect Sheet'. You may be prompted to enter a password if the document's author restricted editing.
Can I delete all buttons and shapes on an Excel sheet at once?
Yes. You can press 'F5' to open the Go To dialog, click 'Special...', choose 'Objects', and click OK. This will select all shapes, charts, and buttons on the active sheet. You can then simply press the Delete key to remove them all simultaneously.
