ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PROTECTING HEADER FOOTER IN EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/172979-protecting-header-footer-excel.html)

Peekabeaux

PROTECTING HEADER FOOTER IN EXCEL
 
Is there anyway I can protect the header footer area in a worksheet?
Thanks
Peek

Dave Peterson

PROTECTING HEADER FOOTER IN EXCEL
 
I don't think so.

If it's really important to you, you could use a workbook_beforeprint event
macro that recreates the header/footer each time print (or print preview is
invoked).

But this will fail if the user disables macros or even disables events.

Peekabeaux wrote:

Is there anyway I can protect the header footer area in a worksheet?
Thanks
Peek


--

Dave Peterson


All times are GMT +1. The time now is 07:24 PM.

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