VBA Show row & column headers

[Pinaceous]

Hi All,

Is there a code through VBA that can hide all row & column headers, for all sheets of your workbook?

Thank you!

Pinaceous

 

[shg]

Sub p()
  Dim wks           As Worksheet
  
  Application.ScreenUpdating = False
  For Each wks In Worksheets
    wks.Activate
    ActiveWindow.DisplayHeadings = False
  Next wks
  Application.ScreenUpdating = True
End Sub

 

[Pinaceous]

Hi shg,

That worked out well, thanks very much!

Would you know how to do its opposite in VBA code?

Thanks,
Paul

 

[Pinaceous]

Hi shg,

I'm sorry, I've got it;

Sub p()
  Dim wks           As Worksheet
  
  Application.ScreenUpdating = False
  For Each wks In Worksheets
    wks.Activate
    ActiveWindow.DisplayHeadings = True
  Next wks
  Application.ScreenUpdating = True
End Sub

Another BIG dua for me!

 

[shg]

You're welcome.