gazzygazgaz
07-21-2021, 02:12 AM
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.
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.