Hi,

How can I protect Headers and Footers in Excel, there doesn't seem to be an
option in eitehr protect sheet or workbook

Thanks

I don't think you can.

I've found that I just apply the headers/footers before each file|print (or
preview).

The user can change them to whatever they want. If macros are enabled, I just
change them back.

There's a workbook_beforeprint event (behind the ThisWorkbook module) that can
be tied into.



LondonLion wrote:

Hi,

How can I protect Headers and Footers in Excel, there doesn't seem to be an
option in eitehr protect sheet or workbook

Thanks

--

Dave Peterson