throtmorton
Board Regular
- Joined
- Aug 9, 2005
- Messages
- 94
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to make a simple macro to let the user hide row and column headers throughout the active workbook.
Here's what I came up with, and I've tried variations on the theme, but it only does the active sheet and won't cycle through to the others. Searched to no avail.
Any help appreciated.
Paul
I'm trying to make a simple macro to let the user hide row and column headers throughout the active workbook.
Here's what I came up with, and I've tried variations on the theme, but it only does the active sheet and won't cycle through to the others. Searched to no avail.
Any help appreciated.
Paul
Code:
Public Sub RowColumnHeaders()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ActiveWindow.DisplayHeadings = False
Next ws
End Sub