Applying worksheet formatting to all sheets in workbook

[Saucer Man]

I have a workbook with 12 worksheets. It is still in develoment so I am
making changes to the formatting to get it the way I want. The changes I
make are on the active sheet. How do I apply the changes to all the sheets
so I don't have to delete them and then Copy the current sheet 11 times
everytime I make a change?

 

[Susan]

you could do it one of two ways. one would be a macro, such as this:

Sub format()
Dim ws as Worksheet

For Each ws In ActiveWorkbook.Worksheets
ws.Range("a1").Font.Bold = True
Next ws

End Sub


the other way would be to select all the worksheets manually, complete
your formatting, and then unselect them.

hope that helps!

susan

 

[Saucer Man]

Selecting the sheets manually before I make the changes is what I was
looking for. I didn't know you could do that. Thanks.


you could do it one of two ways. one would be a macro, such as this:

Sub format()
Dim ws as Worksheet

For Each ws In ActiveWorkbook.Worksheets
ws.Range("a1").Font.Bold = True
Next ws

End Sub


the other way would be to select all the worksheets manually, complete
your formatting, and then unselect them.

hope that helps!

susan

 

[JLGWhiz]

It is amazing what can be found in the help files.

 

[John Keith]

It is amazing what can be found in the help files.

There is probably a wealth of information in the help files, however,
I have never been very successful at entering the right search string
because I rarely find what I'm looking for. Maybe I need to find the
time to read them from page 1 to page n :-(



John Keith
(e-mail address removed)

 

[JLGWhiz]

Learning to use the Excel and VBA terminology will increase the probablitiy
of finding what you need in the help files. For instance, Tab will no bring
up worksheet, but sheet or sheets will. Reading through the files does not
hurt and if you look you will find that there are actually reference manuals
electronically listed in the help facility of both Excel and VBA. They are
organized so that you can easily find information. If you don't see them
when you click on help, then click one of the left and right arrows at the
top of the help pane until they show up..