Hi
In the ThisWorkBook code module put this

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Screenupdating = False
HideRowAndColHeadings
End Sub

bit oblique, but it does the job eventually!
Paul


On May 24, 2:36 pm, "Sandy" wrote:
The following hides the Row and Column Headings for the activesheet. How can
it be adjusted to apply to the whole workbook

Sub HideRowAndColHeadings()
Windows("TestBook.xls").DisplayHeadings = False
End Sub

Thanks Sandy