Help with protecting header/footer
 

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.

Help with protecting header/footer
 

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.

Bruce wrote:

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