| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide or Protect Headers
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide or Protect Headers
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide or Protect Headers
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 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Hide Row & Column Headers in Excel ? | Excel Discussion (Misc queries) | |||
| How do you protect Headers and Footers in MOFFICE | Excel Worksheet Functions | |||
| Hide collapsed group headers on print | Excel Discussion (Misc queries) | |||
| Show/Hide Column and Row Headers | Excel Discussion (Misc queries) | |||
| how to protect column headers from sorting. | Excel Discussion (Misc queries) | |||
Linear Mode
