I don't think you can.

About the only thing you can do is use code that resets the header and footer to
exactly what you want--maybe in the workbook_beforeprint event.

And this will fail if the user disables macros or disables events.

kw wrote:

At work, we use excell to make controlled forms. We often put form numbers
and revision levels in the footer. I know how to control cells in a
spreadsheet, but how do I protect the header and footer?

--

Dave Peterson