NOTE: Many features on the XLplus Web site require Javascript. You can enable Javascript via your browser's preference settings.

XLplus Add-On: Automate Headers and Footers

This Add-On supports you assigning Headers and Footers to every Workbook. It lets you specify your default Headers and Footers and link them to events happening with the workbook. These events can be

Before Print
Before Save

By use of this tool, you can make sure that all of your Workbooks have Headers and Footers, showing information relevant for you.

Additionally, you can assign active settings to the active workbook.

You can choose of the following information:

[FilePath] [FileName] [SheetName]
[FilePath] [FileName]
[FileName]
[SheetName]
[Page] of [Number of Pages]
[Page]
Date Time
[Date]
Autor: [Creator]
Last Changed: [Current User]

Data in Brackets is always dynamically calculated whenever the relevant event occurs.

XLplus Add-On: Automate Header and Footer - Dialog

Use the Dialog to specify your settings. You first can select the information, which shall be given for every Header or Footer.

Example: Select [FilePath] [FileName] [SheetName] to display path, filename and sheetname of the workbook. This could be C:\MyData\MyFile.XLS!Sheet1.

You can specify different information for the left, right or centered Header or Footer. You can specify one setting per Header or Footer only.

Author: This always lists the person, who created the file originally. This cannot be changed or updated.
Last Change: This displays the user, who is working with the file.

Settings

Next, specify for which sheets and on which events Headers and Footers shall be assigned.

You can specify, that all sheets of the active workbook or just the active sheet shall get Page Settings. You can specify two events which fire assignement of Headers and Footers or you can deactivate this function by selecting none of the events. In case you do not select either the

Refresh On Print
or
Refresh On Save

event, no settings will be assigned if these events occur.

Overwrite

You can deactivate this option to prevent overwriting existing Headers and Footers. In this case, only workbooks not containing Headers and Footers get settings assigned.

Details:

In case, you have selected Assign to Active Worksheet, the active sheet is checked for print settings, only. In case, not a single setting exists, the defined Headers and Footers are assigned. In case, you have selected Assign to All Sheets of Workbook, all sheets are checked for existing Headers and Footers. In case, you wish to overwrite existing Headers and Footers, you have to activate Overwrite.

By default, this setting is deactivated.

Tip:

You can use this setting in order to assign Headers and Footers to new workbooks, only. Whenver a new workbook is saved the first time, its page settings are updated. Everytime a workbook with existing Headers or Footers is saved, its settings are kept untouched. To do so, specify as event Refresh On Save and leave Overwrite unchecked.

Whenever you wish to overwrite a sheets Headers and Footers activate Overwrite and raise an event or manually assign settings to the active workbook.

Default Headers and Footers

The default selections, shown the first time you run this XLplus Add-On, gives the following information:

[FilePath] [FileName] [SheetName]
[Page] of [Number of Pages]
Date Time
Autor: [Creator]
Last Changed: [Current User]

Extending Headers and Footers

You can still apply Headers and Footers by using the Page Setup Dialog. You can add, change or delete them as usual. You could extend existing settings by your information. To prevent them from getting overwritten the next time one of the relevant events occurs, deactivate option Overwrite.

Example: In order to apply default Headers and Footers to every new workbook, you specify the Refresh On Save event and leave Overwrite deactivated. After you first saved the workbook you use the Page Setup Dialog to extend the default Headers and Footers.

Assign Now

Use Assign Now to assign the current settings to the active workbook. In order to save your current settings use OK. In case you do not want to permanently overwrite your settings, Cancel the Dialog.