Protecting Headers & Footers in Excel 2003

G

Guest

Hi,

How can I protect Headers and Footers in Excel, there doesn't seem to be an
option in eitehr protect sheet or workbook

Thanks
 
D

Dave Peterson

I don't think you can.

I've found that I just apply the headers/footers before each file|print (or
preview).

The user can change them to whatever they want. If macros are enabled, I just
change them back.

There's a workbook_beforeprint event (behind the ThisWorkbook module) that can
be tied into.
 

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 Headers and Footers!! 2
Headers & Footers _auto update info from a cell in the worksheet 4
Headers and Footers size 2
How can I change the predefined headers and footers in Excel? 2
Headers and Footers 3
transferring headers and footers 1
Is there a shortcut for applying sheet formatting to another sheet 3
Is it possible to set headers and footers to show in normal page . 4

Top