ActiveX
To display customized column headers
- Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
- Set the DAutoHeadings property to False.
- At run time, specify the column header in which to display the custom text by setting the Col and Row properties.
- At run time, supply the text for the column header using the Text property.