I have the following which loops through 19 Worksheets :-

For Each Wksht In Worksheets
With Application
.DisplayFullScreen = False
.DisplayFormulaBar = True
.CommandBars("Worksheet Menu Bar").Enabled = True
.CommandBars("Standard").Visible = True
.CommandBars("Formatting").Visible = True
.CommandBars("Drawing").Visible = True
End With
Next

For Each Wksht In Worksheets
Wksht.Activate
ActiveWindow.DisplayHeadings = True
Next

however I only require it to loop through 7 sheets - say sheets "A" thro
"G". How can I change the above to do that?

Thanks
Sandy