I have generated an excel file, fetched data from sql server and populated the sheet1.

this is a template file (.xlt) .

the column headers are something like this..code, name, branch1...etc.
approximately 1000 rows are being populated.

the problem is when i scroll down the column header disappears, that is normal.
but i want the column header to remain static while scrolling.

i have been going through the Visual Basic for Applications in Microsoft Excel 2002 (vbaxl10.chm) but could not found anything related to this..

i think i am missing any property or method..

please help .

thanks and regards.