Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Data format
I have a Pivot Table and of course when I double Click one of the
totals it fires up a new worksheet with my data. I have a Macro that formats the worksheet the way I want it to look for printing. Is the a way to fire up the macro when I double click one of the totals. Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Data format
You could add code to the ThisWorkbook module, that will run when a new
sheet is added to the workbook. Check the first cell in the new sheet, to see if it matches the first cell in the source data table. For example, if the source data has Date as the first heading, this will run a macro named FormatSheet: Private Sub Workbook_NewSheet(ByVal Sh As Object) If Sh.Cells(1, 1).Value = "Date" Then FormatSheet End If End Sub Little Penny wrote: I have a Pivot Table and of course when I double Click one of the totals it fires up a new worksheet with my data. I have a Macro that formats the worksheet the way I want it to look for printing. Is the a way to fire up the macro when I double click one of the totals. Thanks for your help -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Office 07, how do I format my pivot table data? | Excel Worksheet Functions | |||
Pivot Table Format from Source Data | Excel Discussion (Misc queries) | |||
Format Extracted Data from Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) |