Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 11-12-2018, 07:35 PM
Guessed's Avatar
Guessed Guessed is offline Add, Resize & Relocate Header & Footer with Macros Windows 10 Add, Resize & Relocate Header & Footer with Macros Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,184
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Sizes in Word are in Points (there are 72 points in an inch)

You can use a function to convert cm to units Word understands
.Height = CentimetersToPoints(5.11)
.Width = CentimetersToPoints(20.96)

Bringing in the graphic as an inline shape is somewhat problematic. What if the user doesn't have S drive mapped the same way? I see your preferred width is the same as an A4 page so I assume you were expecting the graphic to start at the top left of the page - you wont get this with an inline shape unless the header space is zero and then the users will get nagged about margins when printing. Are you confident the left margin is always the same in these docs?

FWIW, I would be doing this a different way. I like to save the headers and footers as building blocks in the template itself and then replace the header with that building block.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Header and Footer Diablodvs7 Word 1 07-28-2015 07:54 PM
Header and footer aligned in the footer area ashiqghfr Word 2 07-23-2015 01:14 AM
Add, Resize & Relocate Header & Footer with Macros header footer Pierre-Hugues Word VBA 1 08-30-2013 06:06 AM
How to resize the image in the header so that it fits the page Isadora Excel 1 08-20-2013 06:02 AM
Relocate footnotes to facing page Wydeye Word 0 02-23-2010 05:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft