Won't apply to all worksheets

G

G

This macro will only work on the selected worksheet. It will not
automatically apply to all worksheets in the workbook. How do I make this
macro work on all worksheets? Thanks!


Sub C_Page_Layout()

Dim wks As Worksheet

Application.ScreenUpdating = False

For Each wks In ActiveWorkbook.Worksheets
Columns("A:A").Select
Selection.EntireColumn.Hidden = True
Columns("B:B").Select
With Selection
.ColumnWidth = 20
.HorizontalAlignment = xlLeft
End With
Rows("1:1").Select
With Selection
.Interior.ColorIndex = xlNone
.Font.Bold = True
.Rows.AutoFit
.HorizontalAlignment = xlCenter
End With
Next wks

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top