CommandButton - Created using Forms toolbar
 

This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?

CommandButton - Created using Forms toolbar
 

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?

CommandButton - Created using Forms toolbar
 

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?

CommandButton - Created using Forms toolbar
 

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson

CommandButton - Created using Forms toolbar
 

It is not shared and no sheets are currently grouped.
Thank Dave..


"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson

CommandButton - Created using Forms toolbar
 

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson

CommandButton - Created using Forms toolbar
 

Have been googling the last 10 - 15 minutes, but found this one
suggestion..

ActiveSheet.Buttons.Delete

Thought maybe I'd try this statement from the immediate window
to see if it takes care of it..

Thanks again..




"Dave Peterson" wrote:

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control toolbox
toolbar, click the design icon (the blue-green triangle), and then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson

CommandButton - Created using Forms toolbar
 

And ... did it?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
Have been googling the last 10 - 15 minutes, but found this one
suggestion..

ActiveSheet.Buttons.Delete

Thought maybe I'd try this statement from the immediate window
to see if it takes care of it..

Thanks again..




"Dave Peterson" wrote:

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control
toolbox
toolbar, click the design icon (the blue-green triangle), and
then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson

CommandButton - Created using Forms toolbar
 

My problem is on my Office PC; I'll post back
once I get there (another few hours from now) and try the procedure.
Thanks

"Bob Phillips" wrote:

And ... did it?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
Have been googling the last 10 - 15 minutes, but found this one
suggestion..

ActiveSheet.Buttons.Delete

Thought maybe I'd try this statement from the immediate window
to see if it takes care of it..

Thanks again..




"Dave Peterson" wrote:

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control
toolbox
toolbar, click the design icon (the blue-green triangle), and
then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson

CommandButton - Created using Forms toolbar
 

ActiveSheet.Buttons.Delete

entered from the immediate window removed
the x^&%&^% button !!

Thanks,

Jim

"Bob Phillips" wrote:

And ... did it?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
Have been googling the last 10 - 15 minutes, but found this one
suggestion..

ActiveSheet.Buttons.Delete

Thought maybe I'd try this statement from the immediate window
to see if it takes care of it..

Thanks again..




"Dave Peterson" wrote:

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control
toolbox
toolbar, click the design icon (the blue-green triangle), and
then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson