Remove Row numbers and Column letters from a specifice workbook
 

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

Remove Row numbers and Column letters from a specifice workbook
 

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

Remove Row numbers and Column letters from a specifice workboo
 

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

Remove Row numbers and Column letters from a specifice workboo
 

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