View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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