Command Button

P

Playa

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.
 
D

Dave Peterson

Is your worksheet protected?

Do you have multiple sheets selected (grouped)?

Is your workbook shared?
 
M

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
 
B

BEDE

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