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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting a header/footer 3
Protecting Headers and Footers!! 2
Protection on Header/Footer 1
Protecting header and footer? 1
Header/Footer to update on all sheets 5
Change Header on Multiple Sheets without Changing Other Formatting 1
Header\ Footer Protection 4
Change Header & Footer Info w/ Worksheet Option Buttons 1

Back
Top