Issue with logo proportions after insertion in header

Guessed · #1 10-22-2023, 07:43 PM

If you aren't getting consistent behaviour of the locked aspect ratio then ignore it and make use of the scaleheight and scalewidth eg

Code:

aShp.Width = CentimetersToPoints(3.94)
aShp.ScaleHeight = aShp.ScaleWidth

hank1234 · #2 10-23-2023, 01:07 AM

Quote:

Originally Posted by Guessed

If you aren't getting consistent behaviour of the locked aspect ratio then ignore it and make use of the scaleheight and scalewidth eg

Code:

aShp.Width = CentimetersToPoints(3.94)
aShp.ScaleHeight = aShp.ScaleWidth

Unfortunately, leaving the LockAspectRatio out and adding these two lines of code doesn't do the trick either. I get an error 5148 in the new line of code

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
header format issue	mfitness92	Word	3	07-31-2022 01:03 AM
VBA Insert Image(logo) into header for multiple Word Docs	Axis	Word VBA	4	02-09-2022 10:34 PM
Change Logo in Header in many Word-Documents	ika	Word VBA	15	10-20-2016 11:08 PM
Macro to Insert Logo in header on 1st page only and bookmark it.	youseeme	Word VBA	9	09-16-2016 05:25 AM
How to print header logo only in 1st page	Shafraz Khahir	Word	1	11-29-2010 11:52 AM