Set image object as backgroung of cell and be printable

Greg Truby

MrExcel MVP

Joined

Jun 19, 2002

Messages

10,025

• Jul 24, 2006

• #2

per microsoft...

http://office.microsoft.com/en-us/assistance/HP012138021033.aspx

taken from bam12's post on this thread.

 

Upvote 0

Aaron Blood

Active Member

Joined

Oct 10, 2002

Messages

485

• Jul 24, 2006

• #3

Kinda surprising Excel doesn't offer something like that isn't it?

If watermarks are what you're after, there are ways to do it... Most speak in terms of wordart with a transparency. On printouts the wordart workups look very watermarkish. On the sheet you can tell it overlays the data. I think the MS example above only applies to the more recent version of Excel.

I have two other tricks that I use when wordart just doesn't cut it... One is a VBA method for printing that background that you've noticed can't be printed.

http://www.xl-logic.com/xl_files/formulas/watermark.zip

 

Upvote 0

Greg Truby

MrExcel MVP

Joined

Jun 19, 2002

Messages

10,025

• Jul 24, 2006

• #4

Never played with the .copypicture method, Aaron. Pretty nifty.

(Oh, and FWIW, I rather like your Excel user scale)

 

Upvote 0

ktab

Well-known Member

Joined

Apr 21, 2005

Messages

1,297

• Jul 24, 2006

• #5

Thank you both, I will check the options and links offered, and get back whether worked or not. And yes that's a pitty such a complete program like excel is not to offer something like this..

 

Upvote 0

ktab

Well-known Member

Joined

Apr 21, 2005

Messages

1,297

• Jul 24, 2006

• #6

Aaron Blood i admit that your background print code is just what i needed. I know that i might ask for alot, but as i see it prints out the lines for rows & columns; how can i prevent it?

 

Upvote 0

Greg Truby

MrExcel MVP

Joined

Jun 19, 2002

Messages

10,025

• Jul 24, 2006

• #7

Somewhere before the call to copypicture add a line of code to turn off gridlines... i.e.

Code:

ActiveWindow.DisplayGridlines = False

 

Upvote 0

ktab

Well-known Member

Joined

Apr 21, 2005

Messages

1,297

• Jul 24, 2006

• #8

That worked.
Thank you both Aaron and Greg

 

Upvote 0

F

flyers2thecup

Active Member

Joined

Jul 29, 2004

Messages

362

• Aug 9, 2006

• #9

this doesn't seem to work with LEGAL size pages? is that accurate?

 

Upvote 0

Greg Truby

MrExcel MVP

Joined

Jun 19, 2002

Messages

10,025

• Aug 9, 2006

• #10

I don't have any legal-sized paper to test on. But in looking over the code in Aaron's workbook, I'm not seeing anything that looks to me like it would preclude use on A4 nor US Legal. I would think that one you had the PaperSize property of the PageSetup object defined appropriately and your PrintArea set properly, Aaron's macro would execute just fine. Is that not happening?

 

Upvote 0