Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple workbook that contains a pivot table worksheet. On that
worksheet I inserted the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.PivotTables(2).PivotCache.Refresh End Sub It does not work. It does not appear to be executing at all. When excel opens the workbook, I do not get a warning about macros. How do I fix this to get the code to run? S. Jackson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
option buttons run Click code when value is changed via VBA code | Excel Programming |