Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DisplayHeadings
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DisplayHeadings | Excel Programming |