Worksheet Protection

  • Thread starter Thread starter Patricia Mathis
  • Start date Start date
P

Patricia Mathis

I am attempting to create a spreadsheet that I would like
to protect certain areas from being revised. I have
figured out how to accomplish this pretty much, but need
advice on protecting the header and footer from being
revised. Any advice is appreciated!
 
I've never seen a way to protect the page headers/footers.

But you could always put them back right before the person prints (well, if the
user enables macros.)

You could add some code to the workbook_beforeprint event that resets the
headers/footers of each worksheet.
 
Back
Top