Command Button terror
 

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 ?

"Mark" wrote:

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




-----Original Message-----
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.
.

BEDE

See another answer at your other posting.


Gord Dibben Excel MVP

On Fri, 7 Jan 2005 08:23:04 -0800, "BEDE"
wrote:

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 ?

"Mark" wrote:

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




-----Original Message-----
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.
.