Pivot Table macro to set print area and print details of drill down data

Pivot Table macro to set print area and print details of drill down data

Post by Steve Hask » Wed, 28 Dec 2005 07:24:08


I have created a pivot table from a set of data which the user can select
parameters on to specialise the data and then double-click any total to
drill down to the underlying data. I am trying to design it so that a user
will see all of the underlying data but when they print it it will only
print the leftmost 12 columns. I thought I may be able to do this by
creating a macro that captures the double click event, create the drill down
data sheet and then to record the set print area and header footer
information etc. and then stop recording. Then put this macro in users
workbooks so that when they printed the output it would fit nicely on an A4
landscape page. Is this possible.

Thanks

Steve
 
 
 

Pivot Table macro to set print area and print details of drill down data

Post by Barb Reinh » Wed, 28 Dec 2005 22:37:02

I've not had a lot of success in recording macros for pivot tables.