Formating Pivot drilldown in VBA

[evason75]

Hi all

First post on the forum so here goes.

Using Excel 97 and i have a pivot table. When i use the drilldown i want to autoformat the results by Bolding the column headings and adding an Autofilter etc...

Any ideas of what code i need.

Cheers all

[Norie]

I don't think it's really possible to do this automatically as there is no event triggered when you drilldown from a pivot table.

Doesn't Excel apply some formatting anyway?

[evason75]

Hi Norie

Excel does apply some formatting but it is very limited.

I'm sure it's possible. Anyone else?

[evason75]

Still looking for answers. Can anyone help?