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

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" wrote:

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

Thanks for your swift reply - much appreciated.

AW

"RonaldoOneNil" wrote:

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" wrote:

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

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.

"ArcticWolf" wrote:

Thanks for your swift reply - much appreciated.

AW

"RonaldoOneNil" wrote:

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" wrote:

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