There's not a lot of help out there for working with pivot
tables, but my boss insists that this is the way to go.
So here I am trying to make it work.

I want to write a macro to automate the "show pages"
feature. I have two needs.

1. Is there some code I can use to maintain formatting of
the pivot table when it generates the other pages.

2. Is it possible to use code to delete those pages when
I'm through with them?

I haven't used VB in a few years, so I'm having to relearn
it as I go along.

Thanks for your help.

p.s. Why is there not a pivot table group? Is it because
you are so limited with them that nobody uses them?

Leave it to my group to take a simple tool and try to make
it complex.


-----Original Message-----
<<p.s. Why is there not a pivot table group? Is it
because
you are so limited ....

I guess so. This makes them so simple to use. You can't
have it all ways.


<<.... that nobody uses them?

I thought everybody uses them (they do where I work)
because they are so simple.


Regards
BrianB
---------------------------------------------








"Mel" wrote in message
...
There's not a lot of help out there for working with
pivot
tables, but my boss insists that this is the way to
go.
So here I am trying to make it work.

I want to write a macro to automate the "show pages"
feature. I have two needs.

1. Is there some code I can use to maintain formatting
of
the pivot table when it generates the other pages.

2. Is it possible to use code to delete those pages
when
I'm through with them?

I haven't used VB in a few years, so I'm having to
relearn
it as I go along.

Thanks for your help.

p.s. Why is there not a pivot table group? Is it
because
you are so limited with them that nobody uses them?
.