Gordon, try this,

Sheets.Select
ActiveWindow.DisplayHeadings = False
Sheets(1).Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gordon" wrote in message
...
Hi...

Looking for code that will remove column headings and row numbers from
within the auto open routine. I can do it for a selected sheet but not for
workbook.

Any help appreciated...

G