Automate Excel Headers and Footers Using VBA. ... Find your workbook in the project tree and expand it by clicking on the “+” icon. Right-click on any existing module or the workbook name.

If none of them meets your needs, click on either Custom Header or Custom Footer , which brings up this screen: . By placing your cursor in any of the boxes ( Left section, Center section, Right ...