Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. . |