Did you try using the NewSheet property of the workbook object. I tested
it in xl97 and it worked for me.,


--
Regards,
Tom Ogilvy


"MESTRELLA29" wrote in message
...
Macro to Format the Pivot Table drill down.

I need a way to run a macro when i do a drill down on a pivot table.

what i have is a summary of a source data, that when users access this and
try to get detail, i what to format the sheet that the pivot table
generates
when it does the drill down.

Basically, double click on pivot table opens the drill down detail, then
run
the macro to format this sheet.

Did a made my self clear???