Protecting Headers & Footers in Excel 2003

L

LondonLion

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
 
D

Dave Peterson

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.
 
Top