Pivot Table Drill Down Formatting

  • Thread starter Thread starter Tysone
  • Start date Start date
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.
 
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
 
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
(e-mail address removed)
Click to expand...
 
Back
Top