Pivot Table Data format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Little Penny - 21 Sep 2007 22:16 GMT

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

Reply to this Message

Debra Dalgleish - 22 Sep 2007 03:17 GMT

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

> 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

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message