Forms Command Button - Removal
 

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)?

Forms Command Button - Removal
 

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 wrote:

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

Forms Command Button - Removal
 

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

" wrote in message
:

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 wrote:

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

Forms Command Button - Removal
 

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 wrote:

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

" wrote in message
:

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 wrote:

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

--

Dave Peterson

Forms Command Button - Removal
 

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


" wrote in message
:

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 wrote:

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

" wrote in message
:

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 wrote:

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

--

Dave Peterson

Forms Command Button - Removal
 

Don't forget to try the control toolbox stuff.

JMay wrote:

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

" wrote in message
:

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 wrote:

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

" wrote in message
:

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 wrote:

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

--

Dave Peterson

--

Dave Peterson

Forms Command Button - Removal
 

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

remove nospam for email addy!



"unknown" wrote:

Forms Command Button - Removal
 

Have you tried

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




Dave Peterson wrote:
Don't forget to try the control toolbox stuff.

JMay wrote:

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

" wrote in message
:

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 wrote:

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

" wrote in message
:

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 wrote:

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

--

Dave Peterson

--

Dave Peterson

Forms Command Button - Removal
 

I had the same problem. Once I showed the control toolbox toolbar, I was
able to delete the command button. Thanks.

"Dave Peterson" wrote:

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 wrote:

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

" wrote in message
:

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 wrote:

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

--

Dave Peterson