Display cells in front of object
 

When I insert an object (picture) I want to be able to show the cell contents
in front of the picture. I tried sending object to the back but that did not
work. Any suggestions?

Display cells in front of object
 

Try inserting as a background. You do not give a version but for those up to
2007 FormatSheetBackground...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Goldwing80" wrote in message
...
When I insert an object (picture) I want to be able to show the cell
contents
in front of the picture. I tried sending object to the back but that did
not
work. Any suggestions?

Display cells in front of object
 

Check to see if your picture has a transparency setting. Many pictures (
such as autoshapes) can be made partially or fully transparent, revealing the
data in the underlying cells.
--
Gary''s Student - gsnu200784


"Goldwing80" wrote:

When I insert an object (picture) I want to be able to show the cell contents
in front of the picture. I tried sending object to the back but that did not
work. Any suggestions?

Display cells in front of object
 

VERSION 2003
I want to be able to print it as a background on a form. Doing it as a
background on the sheet encompasses the entire sheet and not the print area I
want to print.

"Nick Hodge" wrote:

Try inserting as a background. You do not give a version but for those up to
2007 FormatSheetBackground...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Goldwing80" wrote in message
...
When I insert an object (picture) I want to be able to show the cell
contents
in front of the picture. I tried sending object to the back but that did
not
work. Any suggestions?

Display cells in front of object
 

Use the Camera tool to copy the sells you want to appear in front of the
object. You'll actually have to replicate the region somewhere else, and
show this image in the Camera tool object, because otherwise the obscuring
object will appear in the Camera image.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Goldwing80" wrote in message
...
When I insert an object (picture) I want to be able to show the cell
contents
in front of the picture. I tried sending object to the back but that did
not
work. Any suggestions?