Forms Command Button - Removal

[JMay]

Several times I've created a command button (from the
Forms Toolbar) to run a given Macro. Later I realize
I wish to delete the macro AND the Command button.
NONE of my workbboks or worksheets are PROTECTED.
When I right-click on the button hoping it will come
Up in edit mode for me to delete - but nothing happens.
Any suggestions (on how to delete an unwanted button)?

 

[Dave Peterson]

Make sure the worksheet is unprotected.

And if by chance, you meant a commandbutton from the Control toolbox toolbar
(not a button from the Forms toolbar), show that control toolbox toolbar and
click on the design mode icon.

Delete the commandbutton and click the design mode button once more.

 

[JMay]

To insure that a Worksheet is Not Protected -- Do you
Do so by going to the Menu, Tools, Protection ,, and if you
See "Protect Sheet..." and "Protect Workbook..." -- then
Neither are protected, RIGHT?

Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..."
Then THEY ARE PROTECTED.. RIGHT?

TIA,
Jim

 

[Dave Peterson]

I glance at the toolbar--when the worksheet is protected lots and lots of icons
are greyed out.

But, yep, going through the menu system should work.

Did you try the control toolbox stuff?

 

[JMay]

I'm 99% sure it is NOT protected; but I'll check it Monday (it's at
work).

 

[Dave Peterson]

Don't forget to try the control toolbox stuff.

I'm 99% sure it is NOT protected; but I'll check it Monday (it's at
work).

 

[Guest]

i find right click and CUT does the trick.....

 

[markpreg]

Have you tried

Tools > Options > View tab > under the "Objects" section, selecting
"show all"