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
|