| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection on Header/Footer
Is there a way to protect/lock the header/footer on a sheet so that it cannot
be modified or removed. I protect the sheet and the worksheet, but the headers and footers are still editible. Is there a way to do this? I have some footers that I do not want to be removed or changed. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protection on Header/Footer
Nothing built in.
Maybe you could just (re)apply the header/footer in the beforeprint event. pt_lily wrote: Is there a way to protect/lock the header/footer on a sheet so that it cannot be modified or removed. I protect the sheet and the worksheet, but the headers and footers are still editible. Is there a way to do this? I have some footers that I do not want to be removed or changed. Thank you! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I widen the page header/footer width? | Excel Discussion (Misc queries) | |||
| An FAQ that never seems to be answered: autofiltering with protection on... | Excel Worksheet Functions | |||
| Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
| workbook protection | New Users to Excel | |||
| protection on excel forms | Excel Worksheet Functions | |||
Hybrid Mode
