Hide or Protect Headers

  • Thread starter Thread starter RLD
  • Start date Start date
R

RLD

How do I prevent others from changing the format of the header and footer. I
tried protecting the sheet but people are still able to edit the header and
footer.
 
Did you lock the cells you want to be protected?
Select all cells to protect, format cells, protection tab, check locked.
Then protect worksheet & apply password then save.
 
I believe this can only be done through VBA.

i.e. a beforeprint event that erases any changes made by users and adds
footers/headers you designate.

Would you need this for all sheets in the workbook?


Gord Dibben MS Excel MVP
 
Back
Top