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"
>> 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??