Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Macro
I have a pivot table and when I double click the pivot cell it fires
up another worksheet with my data. I then run a macro to format the sheet to look the way I want. Is it possible to fire up this macro when I double click the pivot cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Macro
Look at the BeforeDoubleClick event. However this will fire before the
sheet is created. Look at the NewSheet event in the thisworkbook module. It fires for me when I double click a pivot cell. the SH argument in the event tells you what the new sheet name is. You can then check that sheet and see if it has the kind of information that would indicate it is produced by double clicking the pivot cell. Or use both events in combination. -- regards, Tom Ogilvy "Little Penny" wrote: I have a pivot table and when I double click the pivot cell it fires up another worksheet with my data. I then run a macro to format the sheet to look the way I want. Is it possible to fire up this macro when I double click the pivot cell. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Macro
Penny, right click the pivot table sheet tab at the bottom of your screen
where all the sheet tabs are listed. Choose View code and use this event: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) MsgBox "You Double-Clicked Cell " & Target.Address 'Call Your macro here End Sub -- Charles Chickering "A good example is twice the value of good advice." "Little Penny" wrote: I have a pivot table and when I double click the pivot cell it fires up another worksheet with my data. I then run a macro to format the sheet to look the way I want. Is it possible to fire up this macro when I double click the pivot cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table by Macro? | Charts and Charting in Excel | |||
Pivot Table Macro | Excel Discussion (Misc queries) | |||
Pivot Table Macro Help | Excel Programming | |||
Pivot Table Macro | Excel Programming | |||
Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming |