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.