Microsoft Office Forums - View Single Post - Add, Resize & Relocate Header & Footer with Macros

Thread: Add, Resize & Relocate Header & Footer with Macros

View Single Post

Old

11-12-2018, 07:30 PM

AntiqueWhale AntiqueWhale is offline

AntiqueWhale is offline

AntiqueWhale uses Windows 10

Windows 10 AntiqueWhale uses Office 2016

AntiqueWhale uses Office 2016

Office 2016

Novice

Join Date: Nov 2018

Posts: 11

AntiqueWhale is on a distinguished road

Default

In VBA, the size measured in Points, you can use CentimetersToPoints function convert centimeters to points
you can use

Code:

.Width = CentimetersToPoints(20.96)
.Height = CentimetersToPoints(5.11)

Reply With Quote