Command Button

[Guest]

I have a command button in a spreadsheet and I can't move, delete, or right
click it. Anyone know why this might be happening or how I can do something
with it???

Thanks in Advance.

 

[Dave Peterson]

Is your worksheet protected?

Do you have multiple sheets selected (grouped)?

Is your workbook shared?

 

[Mark]

Hi,
You cannot do it without a macro

The object is an OleoObject. if you do not assign a macro
to it on creation, it can sit there forever.

The best way is to copy all your data to a new sheet and
delete the offending sheet.

Or write a macro to delete it.

View Code of the sheet - right click the shhet tab.
Where the dropdown says (General) select Worksheet
In the Sub routine created:

Set AssObj = Worksheets("Sheet1").OLEObjects(1)
AssObj.delete



I haven't tried this yet as I just found it in Visual
Help. Good Luck! We hope you can rid us of this terrible
scourge.

- mark
PS If I have to use an object, I use a picture or shape
object on the sheet. I prefer a toolbar button or a
userform in general.
http://www.geocities.com/excelmarksway
- Mark

 

[Dave Peterson]

I can't recall any time I've _had_ to delete an object with a macro.

 

[Guest]

Thanks!
That 's just what I needed. I had an .xls from somewhere and I simply
couldn't figure how to get rid of that. The commands you suggested in the
WenSlectionChanged did it.
Yet, I still think thare should have been a non-coding solution for this. If
it's visible, then why not to be able to manipulate it with the mouse, like
any picture, chart &c ?

 

[Gord Dibben]

BEDE

See another answer at your other posting.


Gord Dibben Excel MVP