LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BEDE
 
Posts: n/a
Default 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.
.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"