View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lauren Giles Lauren Giles is offline
external usenet poster
 
Posts: 70
Default Magical disappearing shapes!

Okay, this is just... odd. I have a bunch of shapes in an excel document,
most of which I turned into buttons that take you to another sheet in the
document. I'm pretty proud of them.. they go from blue to yellow when you
click them. Anyway, they're gone. I can see the text in them, but the shapes
seem to have run away.

Now, here's the fun part: if I take one of my autoshapes (which happens to
be a bar that separates the headers from the rest of the sheet) and drag it
around, the missing buttons and such reappear, one little strip at a time
(whatever the bar touches). By the way, the bar was invisible as well, I just
knew where it was and clicked on it. The shapes are still there- I can
right-click them and everything. I just wish they'd stay, you know, _visible_.

Oh, and if I drag around my little bar (or make it wider so that I can see
everything) and click away from that spreadsheet and come back to it, all the
shapes are gone again. Even scrolling to another part in the document where
the buttons aren't visible or opening and then minimizing a small window on
top of the document (like this new question window!) makes them go away.
Moving a window around on top of it makes them reappear.. I just figured that
one out. The invisibility extends to the objects in my charts as well. My
objects are also missing when I print preview it, even if they are currently
visible in editing mode.

Any ideas? I really don't care how far-fetched said ideas may be.

Thanks,
Lauren