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?

--
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


On Jan 8, 11:37*am, "Saucer Man" <saucer...@nospam.com> wrote:
> 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 changesI
> 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?
>
> --
> Thanks!

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


"Susan" <(E-Mail Removed)> wrote in message
news:a9695efa-f8e4-4a31-b353-(E-Mail Removed)...
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


On Jan 8, 11:37 am, "Saucer Man" <saucer...@nospam.com> wrote:
> 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?
>
> --
> Thanks!

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



"Saucer Man" wrote:

> Selecting the sheets manually before I make the changes is what I was
> looking for. I didn't know you could do that. Thanks.
>
>
> "Susan" <(E-Mail Removed)> wrote in message
> news:a9695efa-f8e4-4a31-b353-(E-Mail Removed)...
> 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
>
>
> On Jan 8, 11:37 am, "Saucer Man" <saucer...@nospam.com> wrote:
> > 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?
> >
> > --
> > Thanks!
>
>
>
>

On Thu, 8 Jan 2009 09:59:03 -0800, JLGWhiz
<(E-Mail Removed)> wrote:

>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 Removed)

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..

"John Keith" wrote:

> On Thu, 8 Jan 2009 09:59:03 -0800, JLGWhiz
> <(E-Mail Removed)> wrote:
>
> >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 Removed)
>