I have a macro as below that with one click converts a portrait page to landscape and adjusts the header and footer. The header and footer both have three column tables that hold images and fields. It has worked very nicely for over ten years! The macro is stored in a global template in Word\Startup and is run from a number of templates.
Now I have created a new template, again with three column tables and the macro runs except it whilst the ruler shows the landscape page width when the cursor is in the body of the document, the page width when in the header has not adjusted.
Screenshot 1 shows the new template with the cursor in the body.
Screenshot 2 shows the old template with the cursor in the body. Ruler shows same width.
Screenshot 3 shows the new template with the cursor in the body.
Screenshot 4 shows the old template with the cursor in the header. Ruler shows a different width.
I have attached the macro as a text file. The last macro in the file runs the others in turn.
Can anyone see what I am missing please? I am not a VB expert. Most of my macros are recordings or hacks of recordings.