ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Send clipart behind text??? (https://www.excelbanter.com/excel-discussion-misc-queries/147851-send-clipart-behind-text.html)

Pam

Send clipart behind text???
 
How do you send the clipart to set it behind the text? Send to back dosen't
set it behind the text. Need help

Jon Peltier

Send clipart behind text???
 
Send to Back moves the clipart behind other objects (shapes, charts,
buttons) in the drawing layer, but the drawing layer still obscures the
cells.

You could put the text into textboxes, which lie in front of the clipart in
the drawing layer. Not ideal. You can make a textbox (or other shape)
display text from a cell by selecting the textbox, not in text edit mode,
clicking in the formula bar, typing =, then clicking on the cell with the
mouse.

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


"Pam" wrote in message
...
How do you send the clipart to set it behind the text? Send to back
dosen't
set it behind the text. Need help




Gary''s Student

Send clipart behind text???
 
If you need to see the worksheet behind the clipart, try making it
semi-transparent.

This only works with some shapes (like Autoshapes)
--
Gary''s Student - gsnu200733


"Pam" wrote:

How do you send the clipart to set it behind the text? Send to back dosen't
set it behind the text. Need help



All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com