Remove Row numbers and Column letters from a specifice workbook

[ArcticWolf]

Hi,

I don't want to turn it off for all of Excel permantley - just for one
specific workbook that I'm using. Is there some code I can put in the
workbook so that everytime it's opened they're gone - but are still active
for all other Excel workbooks? Using Excel 2003.

Thanks in advance,

AW

 

[RonaldoOneNil]

In the VBA editor for This workbook put this code (substitute test for your
workbbok name)

Private Sub Workbook_Open()
Windows("Test").DisplayHeadings = False
End Sub

 

[ArcticWolf]

Thanks for your swift reply - much appreciated.

AW

 

[RonaldoOneNil]

Further to this, when I open a workbook and select to turn off the row and
header labels, it only applies to this workbook. If I open another workbook,
they are not turned off in that.