Help with protecting header/footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey,

I'm trying to send out a worksheet to clients that contains copyright
information in the footers of the excel file. I don't want those to be
changed, yet when I protect a sheet it still allows a user to edit them. Is
there a way to protect the footer?

Thanks.
 
Not that I know.

Maybe you could tie into the workbook_before event and put the headers in each
time the user hits print or print preview.

If macros are turned off, this won't help.
 
Back
Top