Shapes, Cells and Z-Order

  • Thread starter Thread starter Jonathan Furman
  • Start date Start date
J

Jonathan Furman

I'm trying to pretty up a workbook by adding some shapes and I'm curious if
there was a way to cause a cell (and it's contents and formatting) to appear
above a shape. More specifically I'd like to add a sort of frame around a
range with a color fill gradient and shadows but have the cells in the
location appear above it. I'v fooled around with send to back on the shapes
and different combinations of transparency and pattern settings but the
shape always appears "on top" of the cells. Just curious if there was a way
to do this?


Jon
 
Jon,

You can't put anything in back of the cells. The Z order is for graphics
only, and all are in front of the cells. Only the background image
(Format - Sheet - Background) can go in back of cells.
 
Thanks for the answer..that being the case I will waste no more time trying
to do something that can't be done! 8 )


Jon
 
Back
Top