Protect HEADER and FOOTER ?
AP,
As far as I can tell, protection (in XL2K) does not cover the header/footer.
But you could respond in the Workbook_BeforePrint event to set them to
whatever you want.
This events fires on PrintPreview as well as actual printing, so an
incorrect header/footer would never actually be seen.
NickHK
"AP" wrote in message
...
Although I've protected the worksheet, users can still edit the HEADER and
FOOTER.
Is there code or any other way of protecting the HEADER and FOOTER from
being edited ?
Thanks very much for your help.
AP
|