Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Format the Pivot Table drill down
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Format the Pivot Table drill down
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??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Format the Pivot Table drill down
Sorry,
can you be more specific? "Tom Ogilvy" wrote: 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??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Format the Pivot Table drill down
I meant NewSheet event
See Chip Pearson's page on events if you are not familiar: http://www.cpearson.com/excel/events.htm When you drill down, a new sheet is created and triggers the newsheet event with a reference to the new sheet. You can have your code check if it is of the format of the pivottable and then do your formatting if it is. -- Regards, Tom Ogilvy "MESTRELLA29" wrote in message ... Sorry, can you be more specific? "Tom Ogilvy" wrote: 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??? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Format the Pivot Table drill down
thanks,
I will try this and see if it works... "Tom Ogilvy" wrote: I meant NewSheet event See Chip Pearson's page on events if you are not familiar: http://www.cpearson.com/excel/events.htm When you drill down, a new sheet is created and triggers the newsheet event with a reference to the new sheet. You can have your code check if it is of the format of the pivottable and then do your formatting if it is. -- Regards, Tom Ogilvy "MESTRELLA29" wrote in message ... Sorry, can you be more specific? "Tom Ogilvy" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Drill Down | Excel Discussion (Misc queries) | |||
Pivot table drill down | Excel Discussion (Misc queries) | |||
Pivot Table drill down | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Top 10 within a drill-down in a pivot table? | Excel Discussion (Misc queries) |