Hi guys,

VBA newbie here looking to disable/grey out the button for "insert header & footer" on the ribbon on Excel 2016.

I currently already have a module to replace all headers & footers with my desired custom settings but would also like to prevent anybody to edit it.

I have done a search in the forum and on Google but only found older threads for earlier versions of Excel.

Really appreciate any assistance! Thank you.