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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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.
 
Upvote 0
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. :)
 
Upvote 0

Forum statistics

Threads
1,224,606
Messages
6,179,866
Members
452,948
Latest member
UsmanAli786

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
Back
Top