Celia has attended:
Excel Intermediate course
Excel Advanced course
Printing templates
I am in process of standardising approx 100 templates and would like to ensure that the print area is consistent across all templates, How do I this?
RE: Printing templates
Hi Celia, thanks for your query. This depends a lot on where you are in the process. Ideally, you would create one template with the print area set and then create your 100 other bespoke templates from that, thereby controlling the print area across all the others. If your templates have already been created there is no built in functionality to help you standardise the print areas and you would have to write a macro to loop through all 100 files, set the print area and then save the template. Other than that, it will be a manual process!
Hope this helps,
Anthony
