Pivot Table Drill Down Formatting

T

Tysone

Has anyone figured out how to auto format the data when you drill down
in a pivot table? I know it's not that hard to push the $ button, and
change some header colors and what not... I just wish there was a
quick fit. If not, any macro ideas for when a new sheet is created??

Thanks.
 
N

Nick Hodge

Tysone

In XL2003 (may have been available in XP too), you could use the
Workbook_NewSheet() event, something like thus:

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Columns("I:I").NumberFormat = "£0.00"
End Sub
 
T

Tysone

Ahhh - Perfect Nick, thanks for the help.

Tyson

Nick Hodge said:
Tysone

In XL2003 (may have been available in XP too), you could use the
Workbook_NewSheet() event, something like thus:

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Columns("I:I").NumberFormat = "£0.00"
End Sub

--
HTH
Nick Hodge
Southampton, England
[email protected]
Click to expand...
 
Top