Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graphics file/ How do I move it to the back of a worksheet?
I have imported a graphics file that is displayed over a worksheet
(Application for title). It basically hovers above the spreadsheet. I have set up the spreadsheet to import data from a "deal sheet" so that the application is ready to print from the given data on the deal sheet in the right place on the graphic. The problem is, that some parts of the graphic are solid so that data behind that part is hidden behind the graphic. Is there a way to put the spreadsheet "on top" so that the data from the cells is printed and visible? Thanks!!! Brian PS, I do not at this time use VBA, but would love to learn if that is the only way to make this work. If it is, I need a place to get basic info on how to use VBA. Brian |
#2
|
|||
|
|||
hi
there are two ways you can do it.. 1. select the picture. go to formatobjectcolors and lines. choose 'no fill' or semitransparent in fill option. 2. go to formatsheetbackground and browse the graphic file. it will be set as background to the worksheet. vicky "B. E. Smith" wrote: I have imported a graphics file that is displayed over a worksheet (Application for title). It basically hovers above the spreadsheet. I have set up the spreadsheet to import data from a "deal sheet" so that the application is ready to print from the given data on the deal sheet in the right place on the graphic. The problem is, that some parts of the graphic are solid so that data behind that part is hidden behind the graphic. Is there a way to put the spreadsheet "on top" so that the data from the cells is printed and visible? Thanks!!! Brian PS, I do not at this time use VBA, but would love to learn if that is the only way to make this work. If it is, I need a place to get basic info on how to use VBA. Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move my worksheet from under the toolbar? | Excel Discussion (Misc queries) | |||
save an Excel worksheet as a comma delimited file? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
is there a shortcut to move from one worksheet to another, in Exc. | Excel Discussion (Misc queries) | |||
move the worksheet tabs in a workbook to left | Excel Discussion (Misc queries) |