ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protection on Header/Footer (https://www.excelbanter.com/excel-discussion-misc-queries/102347-protection-header-footer.html)

pt_lily

Protection on Header/Footer
 
Is there a way to protect/lock the header/footer on a sheet so that it cannot
be modified or removed. I protect the sheet and the worksheet, but the
headers and footers are still editible.

Is there a way to do this? I have some footers that I do not want to be
removed or changed.

Thank you!

Dave Peterson

Protection on Header/Footer
 
Nothing built in.

Maybe you could just (re)apply the header/footer in the beforeprint event.

pt_lily wrote:

Is there a way to protect/lock the header/footer on a sheet so that it cannot
be modified or removed. I protect the sheet and the worksheet, but the
headers and footers are still editible.

Is there a way to do this? I have some footers that I do not want to be
removed or changed.

Thank you!


--

Dave Peterson


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com