Pivot Table Drill Down Formatting

Pivot Table Drill Down Formatting

Post by tmune » Wed, 15 Oct 2003 03:25:03


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.
 
 
 

Pivot Table Drill Down Formatting

Post by Nick Hodg » Wed, 15 Oct 2003 03:42:30

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 = ".00"
End Sub

--
HTH
Nick Hodge
Southampton, England
XXXX@XXXXX.COM



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

 
 
 

Pivot Table Drill Down Formatting

Post by tmune » Wed, 15 Oct 2003 22:53:16

Ahhh - Perfect Nick, thanks for the help.

Tyson



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