MS Excel 2010 - Header/Footer

[Jewelzz]

Any MS Excel 2010 gurus out there that can tell me if, and how, you can password protect the header/footer so it can't be changed/deleted?

 

[LeeJend]

You have to install the DRM package if you don't have it already. (BTW If I come back screaming at you it will mean I was unable to get rid of this DRM install that I triggered looking into your question...)

Start at the windows button, Prepare button, restrict permissions.

Not sure if it will protect the Header and am too chicken to risk my install by adding the DRM package and checking. 🙁

 

[American Zombie]

You don't need to install anything just create a macro.

Do a search on lock/protect header and footers excel and you should find many hits with the info of how to do it.

 

[Jewelzz]

Thanks guys