How can I make this macro run on all sheets?

[tonywatsonhelp]

Hi Everyone

I have this code that hides tabs, headings, gridlines for the sheet i'm on but I'd like it to run on everysheet when the document opens
how can I change this so instead of "activeWindow" it say "Every Sheet"??

Sub Full_Screen()
Application.ScreenUpdating = False

Application.ActiveWindow.DisplayWorkbookTabs = false
Application.ActiveWindow.DisplayHeadings = false
Application.ActiveWindow.DisplayGridlines = false

End Sub

Thanks

Tony

 

[dfsobral]

you can always loop though all sheets

Sub LoopSheets()
Dim sh1 As Worksheet
Dim sh2 As Worksheet


Set sh1 = ActiveSheet


For Each sh2 In Worksheets
    sh2.Activate
    < your code >
Next sh2


sh1.Activate

End Sub