Inserting a picture as a watermark

[Willyg1977]

I have tried and tried and cannot figure out how to get my company logo "underneath" my spreadsheet to act as a watermark. Can this be done and if so how?

 

[Mark O'Brien]

"Format|Sheet|Background"?

HTH

EDIT:: Bollox, no, that doesn't print.
_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-09-27 14:46

 

[Dragracer]

For a printable watermark check this out

http://www.mrexcel.com/board/viewtopic.php?topic=5782&forum=2

 

[Tron57]

this site has some good downloadable examples...
http://www.xl-logic.com

 

[Jack in the UK]

Sub Add__Watermark()

Dim StrIn As String
StrIn = InputBox("Enter text")
If StrIn = "" Then Exit Sub

With ActiveSheet.Shapes.AddTextEffect(msoTextEffect9, StrIn, _
"Arial Black", 36#, msoFalse, msoFalse, _
10, 10)
.ScaleWidth 2, msoFalse, msoScaleFromTopLeft
.ScaleHeight 2, msoFalse, msoScaleFromBottomRight
.Fill.Visible = msoTrue
.Fill.Solid
.Fill.ForeColor.SchemeColor = 26
.Fill.Transparency = 0.5
.Shadow.Transparency = 0.5
.Line.Visible = msoFalse
'position at cell corner
.Top = Selection.Top
.Left = Selection.Left
End With

End Sub

MARKER WATER MARK