Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Headers and Footers!!
When I protect the worksheet it does protect most of the formatting and
inserting and deleting rows and columns. I want to protect my workseet in such a way that user cannot go to View Headers / Footers or File Page set up and change the Headers and Footers!! Is it possible? how do I do this setting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Headers and Footers!!
Hi,
A bit drastic maybe but you could do this, You would need to re-enable it at some point; probably workbook close by changing False to True. This does however depend on macros being enabled which may not be the case. Private Sub Workbook_Open() With Application.CommandBars("Worksheet Menu Bar") With .Controls("&View") .Controls("&Header and Footer...").Enabled = False End With End With End Sub Mike "Raja" wrote: When I protect the worksheet it does protect most of the formatting and inserting and deleting rows and columns. I want to protect my workseet in such a way that user cannot go to View Headers / Footers or File Page set up and change the Headers and Footers!! Is it possible? how do I do this setting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Headers and Footers!!
I don't think you can protect this.
If it's really important, you could put code into the workbook_Beforeprint event that makes sure the headers/footers are what you want. But that would fail if the user disabled macros or even disabled events. Raja wrote: When I protect the worksheet it does protect most of the formatting and inserting and deleting rows and columns. I want to protect my workseet in such a way that user cannot go to View Headers / Footers or File Page set up and change the Headers and Footers!! Is it possible? how do I do this setting? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headers/footers | Excel Worksheet Functions | |||
Headers and Footers | Excel Discussion (Misc queries) | |||
Headers & footers | Excel Discussion (Misc queries) | |||
headers and footers | Excel Discussion (Misc queries) | |||
Protecting Headers & Footers in Excel 2003 | Excel Discussion (Misc queries) |