How to protect footer in excel sheet?

[NonStopLeo]

Hi Friends

I have a protected sheet with footer.

I have shared this sheet with my team members, but I have observed that they are able to change/delete the footer, even my sheet is protected.

can any one please give me the solution, how I can protect my footer as well.

Regards

 

[NonStopLeo]

Please help

 

[RoryA]

There are no protection options for that, I'm afraid. You could use code in a BeforePrint event to reset the headers and footers if it's really important.

 

[NonStopLeo]

Can you please create a vb code for this?

 

[RoryA]

I believe you had an example provided in one of your cross posts. Please note the forum rules on that and comply with them in future.

 

[Fazza]

one idea, it may not suit your needs, but maybe it does : provide the information as a pdf

 

[NonStopLeo]

There are no protection options for that, I'm afraid. You could use code in a BeforePrint event to reset the headers and footers if it's really important.

My sample sheet is attached...

https://jumpshare.com/v/PzaWx2BeNcQOWUDqpx9u