lost objects in Excel

  • Thread starter Thread starter Den
  • Start date Start date
D

Den

I have had numerous incidents of Excel "forgeting" what kind of object is
embedded in a spreadsheet. For example I have placed some Command Buttons
on a spreadsheet and for no known reason they forget they are command
buttons and revert to a picture object. I have also placed Word objects in
a spreadsheet and have the same thing happen. They just revert to picture
objects.
The only way I have found to fix it, is to delete the object and re-insert
it into the spreadsheet again.

Anyone else run into this. Any ideas?

Dennis
 
Den said:
I have had numerous incidents of Excel "forgeting" what kind of object is
embedded in a spreadsheet.
Click to expand...

Not heard of that before.
What do you see in the formula bar if you select the object after it has
been "forgotten"?
What is the setting in Tools / Options / View / Objects?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
I don't know Bill, I have not taken notice of that information. It happens
fairly frequently, but I cannot reproduce it at will, so I will have to wait
until it happens again and make note of that information.

Thanks
Dennis
 
Back
Top