Amend text shape in header with VBA

macropod · #10 09-22-2016, 01:16 AM

Quote:

Originally Posted by Welshgasman

We do have a blue line below the logo and text box, but that has moved down as well, so all is good.

In my testing the blue line didn't move.

Quote:

Originally Posted by Welshgasman

I was thinking about it last night and *thought* I might need to check if it is > than current .PageSetup.TopMargin and then only change it, else it could be reduced depending on what is in the page header.

With the alternative approach I suggested, such testing isn't necessary. Indeed, if you look at the code I posted for that, you'll see there's not even a reference to sHght.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
selecting shape in header only	mhagi	Word VBA	5	10-09-2015 01:10 AM
Get the TEXT of Clicked Shape	exceere	Excel Programming	9	07-09-2014 06:51 AM
how to paste text as shape	bsapaka	Excel	1	05-01-2014 06:53 AM
Excel vba adding field in word table/shape in a header	Hdr	Excel	1	02-04-2013 04:40 PM
Amend footer in multiple word docs?	compact	Word	2	02-24-2009 09:40 AM