Consulting | Excel Examples

Select Custom Header

Keywords: Custom Dialog, Header, Option Buttons

Description: Custom Dialog box and Visual Basic for Applications procedure provides a choice of three custom headers that can be assigned to a worksheet.

Tip: You can have Excel store frequently used custom headers and choose them from a menu option in a worksheet. A Visual Basic for Applications procedure and custom dialog can be used to store header information, select a header using options buttons and copy the header information to the three header areas of the PageSetup object.

Guide to the Example:
To use the macro, select "Custom Header" from the Tools menu option. Change one of the three custom headers, select the header and print worksheet. To make this file into an Add In, choose menu option Tools..Make Add In. Excel will create an add-in file that you can add to any open workbook with Tools..AddIns option. See the Excel manual for instructions on "installing Add-Ins"

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

 

Last modified: May 21, 1996