View Full Version : Row & Column Indicators
Nologik
07-19-2008, 05:51 PM
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
07-19-2008, 06:00 PM
You can run this to toggle them shown or hidden.
Sub noRowCol()
ActiveWindow.DisplayHeadings = False = Not ActiveWindow.DisplayHeadings = False
End Sub
Nologik
07-19-2008, 06:04 PM
You are the man ! Thank you so much.
Aussiebear
07-19-2008, 06:10 PM
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
07-19-2008, 06:44 PM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.