Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table macro to set print area and print details of drill down data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table macro to set print area and print details of drill down data
I've not had a lot of success in recording macros for pivot tables.
"Steve Haskins" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table macro to set print area and print details of drill dow
Generally, anything that can be done manually can be automated. Have you
tried recording a macro for this and has it not worked? What happens? "Steve Haskins" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |