Cannot delete a command button from a worksheet - Even in Design Mode

Robert_Conklin

Board Regular
Joined
Jun 19, 2017
Messages
173
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have place a command button on a worksheet to run a macro, but when I click the button it says that it cannot find the macro. I wanted to delete everything and start again, but when I enter Design Mode on the Control Toolbar I cannot select the button, move it, or anything. Any advice would be great!
 
Yes, it is a shared file. I unchecked that feature and was able to make the changes! Thanks!
 
Upvote 0

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Another mystery solved! NB: SHaring files is a bad idea, the feature is shaky at best. Better start using Office 365 and its co-authoring feature, it is much more reliable.
 
Upvote 0
It is the Autosave button in the top-left-hand corner. It is only enabled when your file resides on OndeDrive (for business or personal) or on Sharepoint.
 
Upvote 0
Got it! I am talking with my IT group now about getting a sharepoint drive set up for me. Thanks for the tips!!
 
Upvote 0

Forum statistics

Threads
1,215,455
Messages
6,124,938
Members
449,197
Latest member
k_bs

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