LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Drill Down EarlyBirdie Excel Discussion (Misc queries) 0 February 27th 08 06:07 PM
Pivot table drill down In a quandry Excel Discussion (Misc queries) 0 November 12th 07 02:56 PM
Pivot Table drill down Beccy Excel Discussion (Misc queries) 1 March 1st 07 02:20 PM
Pivot Table macro to set print area and print details of drill down data Steve Haskins Excel Discussion (Misc queries) 2 December 28th 05 04:59 PM
Top 10 within a drill-down in a pivot table? ChrisBusch Excel Discussion (Misc queries) 8 June 2nd 05 08:36 PM


All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"