Can't Record Macro which changes formatting

The simple answer is that the macro recorder doesn't record everything you can do through the GUI. In any event, unless your document is configured with either a 'different first page' layout or has a Section break between the first & second pages, with the second Section's header & footer unlinked from the first Section, what you're trying to do would affect every page. Provided those conditions are satisfied, you could use a macro like:

Please Login or Register  to view this content.

Originally Posted by AllisonNS

Well that is just silly to have a recorder which isn't set up to record everything..... Kind of defeats the purpose.

The macro recorder can record your actions in this case. I don't know what you did that meant nothing was recorded.

That said, the macro recorder can't record everything in Excel, either, so I'm surprised you didn't know its limitations already. Moreover, no matter which application you're using, the macro recorder is as dumb as a box of rocks: it records a lot of irrelevant stuff; records actions using Activate, Select, etc., which are very inefficient. It's completely clueless about loops and a whole bunch of other stuff. FWIW, this is the code I get using the macro recorder:

Please Login or Register  to view this content.

Aside from all the unnecessary stuff it's recorded, it would only work correctly if your insertion point was on the first page; run it from anywhere else and it'll wipe out your header/footer there, instead. It also forces your display into PrintView display mode regardless of what mode you're working in. The code I wrote can be run from anywhere, will only affect the header/footer that appears on the first page, and Doesn't alter your display mode. Knowing now that you have a 'different first page' setup, could be reduced to:

Please Login or Register  to view this content.