LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Placing an absolutely positioned image on every printed page

I have a problem. My office is changing its logo/profile and all
templates needs to be updated. It's a fairly simple layout with the
new company logo as a tif (or eps) placed ~ x:14mm y:7mm from the top
left corner of an A4 sheet. The left margin of the page should be 30mm
(the logo starts within the left margin). When printed as landscape the
logo needs to be rotated 90 degrees and posi-tioned along the right
short side (we want all headers to look the same when the pages are
placed in a folder)

Result: a fairly simple layout, with big problems:

1. The image can't be placed in the header because of the minimum 1
inch "header left margin" default.

2. On a portrait A4 the logo can be positioned in the first row (the
first column has to be left out blank, to compensate for the 30mm left
margin, which isn't very practical) but for landscape this can't be
done as it isn't possible to repeat a column on the right side of the
page.

I'm looking for a macro that places an image exactly x,y from the top
left (or top right when land-scape) of every printed page
(_BeforePrint). Ideally the image needs to be placed outside the
left/right margin. Is it possible to freely place an image outside of
the page margins?

Headaches...

I'm thankful for any help I can get.

deage

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no image printed in excel 2010 nzdooly Excel Discussion (Misc queries) 0 May 25th 10 08:01 AM
TIFF image moves for no reason when printed Nikko963 Excel Discussion (Misc queries) 1 July 28th 09 10:25 PM
printed image to small john hillock Excel Discussion (Misc queries) 4 June 3rd 07 05:54 AM
Downloading image and placing in cell. Raydr Excel Programming 1 November 13th 04 01:50 AM
placing a point on a image Peter Meulenmeesters Excel Programming 1 April 8th 04 06:37 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"