Prev: Top menu
Next: Excel data merging into Word
From: RLD on 14 Mar 2010 20:57
How do I prevent others from changing the format of the header and footer. I
tried protecting the sheet but people are still able to edit the header and
footer.
From: evoxfan on 15 Mar 2010 10:31
Did you lock the cells you want to be protected?
Select all cells to protect, format cells, protection tab, check locked.
Then protect worksheet & apply password then save.


"RLD" wrote:

> How do I prevent others from changing the format of the header and footer. I
> tried protecting the sheet but people are still able to edit the header and
> footer.
From: Gord Dibben on 15 Mar 2010 11:15
I believe this can only be done through VBA.

i.e. a beforeprint event that erases any changes made by users and adds
footers/headers you designate.

Would you need this for all sheets in the workbook?


Gord Dibben MS Excel MVP

On Sun, 14 Mar 2010 17:57:01 -0700, RLD <RLD(a)discussions.microsoft.com>
wrote:

>How do I prevent others from changing the format of the header and footer. I
>tried protecting the sheet but people are still able to edit the header and
>footer.

 | 
Pages: 1
Prev: Top menu
Next: Excel data merging into Word