Help with protecting header/footer

[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.

 

[Dave Peterson]

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.