How to get rid of the button?

shadi

New Member
Joined
Sep 14, 2010
Messages
22
Hi Everyone,

I've got an axcel macro enabled file, there is a command button on one of the sheets, that can not be deleted!!! I simply can't get rid of it. I can delete the related codes, so it does not do anything but it's still there!! Can anybody help me?

Shadi
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

hallingh

Well-known Member
Joined
Sep 11, 2010
Messages
769
Are there other command buttons that you dont want to be deleted? I once had a problem with a ton of checkboxes on top of each other, but I didnt have any checkboxes I needed so I wrote a piece of code that simply deleted all checkboxes in my workbook and I was good to go.
 

cameron.richens

New Member
Joined
Nov 12, 2010
Messages
24
right click on the button then click "assign macro" then delete the macro name from the selection box.

once you have removed the macro from the Button it can be freely deleted. :)
 

Forum statistics

Threads
1,141,847
Messages
5,708,950
Members
421,601
Latest member
Garlo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top