I have several DOZEN workbooks with 6 worksheet's in each of them that I am working on, and I have to adjust several settings in the PAGE SETUP settings as well as the FOOTER's to every worksheet in every workbook.
The "Page Setup" settings as well as the "Footer" is going to be the same across ALL workbooks and worksheets.
Is there a way to set the "Page Setup" settings and "Footer" to apply "Alll Workbooks" and "All Worksheets" at one time?
It's a massive headache trying to make all these settings individually...
Thank you in advance for your help!!
All the best,
Chris
The "Page Setup" settings as well as the "Footer" is going to be the same across ALL workbooks and worksheets.
Is there a way to set the "Page Setup" settings and "Footer" to apply "Alll Workbooks" and "All Worksheets" at one time?
It's a massive headache trying to make all these settings individually...
Thank you in advance for your help!!
All the best,
Chris