Protecting Headers & Footers in Excel 2003
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 |
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. LondonLion wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 06:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com