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