Hi All,
Can someone please help with a VBA code, so that the code can insert information on the LeftFooter, CentreFooter and RightFooter for the active selected worksheets in a workbook?
I didn't want to use "add heater & footer" function in the excel, as people can make changes to it. Therefore, I am thinking of a VBA code for this application to prevent people from modifying footer information.
Can someone please help with a VBA code, so that the code can insert information on the LeftFooter, CentreFooter and RightFooter for the active selected worksheets in a workbook?
I didn't want to use "add heater & footer" function in the excel, as people can make changes to it. Therefore, I am thinking of a VBA code for this application to prevent people from modifying footer information.