Row & Column Indicators

[Nologik]

Hey guys, is there any way through VBA or some other way to remove the row and column indicators in an excel workbook?

Thank you!:beerchug:

[david000]

You can run this to toggle them shown or hidden.

Sub noRowCol()
ActiveWindow.DisplayHeadings = False = Not ActiveWindow.DisplayHeadings = False
End Sub

[Nologik]

You are the man ! Thank you so much.

[Aussiebear]

An alternative that I found works for me.


Private Sub Workbook_Open()
ActiveWindow.DisplayHeadings = False
End Sub


This code needs to be placed in the This Workbook module

[mdmackillop]

You can run this to toggle them shown or hidden.

Sub noRowCol()
ActiveWindow.DisplayHeadings = False = Not ActiveWindow.DisplayHeadings = False
End Sub


Hi David,
You can simplify this to


Sub noRowCol()
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End Sub