Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I lock footers in Excel?
I am using excel spreadsheets as templates for others to use. I can set them
up so that they can only modify certain cells throught the spreadsheet. How can I keep them from changing the header or footer? |
#2
|
|||
|
|||
I don't think you can.
About the only thing you can do is to put them back the way you want them right before you print/printpreview. You could record a macro that sets them the way you want, then put that code into the ThisWorkbook module under the workbook_beforeprint routine. If you have trouble modifying your recorded macro, post back. Al@Kohler wrote: I am using excel spreadsheets as templates for others to use. I can set them up so that they can only modify certain cells throught the spreadsheet. How can I keep them from changing the header or footer? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel Footers | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |