water mark

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 1, 2002

• #2

Looks like Damon created a procedure for this:

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

 

Upvote 0

W

white6174

Board Regular

Joined

May 6, 2002

Messages

137

• Sep 1, 2002

• #3

One easy way I find is by using word art and having no fill color just border.

steve w

 

Upvote 0

N

NCay

Board Regular

Joined

Jul 15, 2002

Messages

214

• Sep 1, 2002

• #4

still can't get this to work. Any further explanations would be good.

BTW i'm using office XP

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Sep 1, 2002

• #5

which method did you try? what errors did you get?

Paddy

 

Upvote 0

N

NCay

Board Regular

Joined

Jul 15, 2002

Messages

214

• Sep 1, 2002

• #6

I thought that there was a simple way to place a picture behind the data on the sheet as a transparency or watermark, though I seem to be completely LOST this time, I believe there is an insert picture- image control command in office 2k that does this, but am struggling to find an equivalent in office xp/ excel 2002.
Current attempts leave picture ABOVE the data, even after using the send to back command. Am I missing something??

 

Upvote 0

N

NCay

Board Regular

Joined

Jul 15, 2002

Messages

214

• Sep 1, 2002

• #7

Thanks Steve W, eventually managed to lose the Monday morning feeling and got this way to work! Though must admit I am disappointed that this is the only simple way to achieve this- especially when there is a Word equivalent devoted to doing this.

 

Upvote 0

V

Vlad

New Member

Joined

Aug 31, 2002

Messages

7

• Sep 1, 2002

• #8

Hi all,

One of the ways (thanks, Aaron Blood) is to paste picture link. I'm talking about Excel 2000.

But we have to use reverse logic: you create a watermark, do the coloring, transparency, all the things necessary, WordArt, etc and only THEN you select the data, copy. Push shift and superimpose the picture link with data on top of your watermark.

Works.

 

Upvote 0

Todd Bardoni

Well-known Member

Joined

Aug 29, 2002

Messages

3,042

• Sep 2, 2002

• #9

If you have a bitmap or jpeg of the word "DRAFT" then you can go to Format, Sheet, and then Background. This will insert the word Draft in your backgroung, although I don't think it prints. Otherwise, I've just used Word Art. I use a light grey outline with no fill...works great!

 

Upvote 0

C

Chris Davison

MrExcel MVP

Joined

Feb 15, 2002

Messages

1,790

• Sep 2, 2002

• #10

tbardoni's right, it won't print

check out the settings within your printer settings from the start menu in Windows..... mine all have a watermark option for printing

 

Upvote 0