Code doesn't work from in Office 2003

  • Thread starter Thread starter Dennis Cheung
  • Start date Start date
D

Dennis Cheung

The following code worked fine in office xp but not in 2003

Private Sub Worksheet_Calculate()
Application.EnableEvents = True
Run ("SelectAfter")
Application.EnableEvents = True
End Sub

The problem is when I tried to unhide rows in the sheet, the marco
"SelectAfter" runs. And I only need it runs when somethng changed in PVT. It
worked fine in XP version but above situiation happened after I changed to
2003.
The marco SelectAfter means to hide 2 rows after select other items in PVT.

Can someone help?
 
Thanks Jacob. After following your code,
The marco didn't run when I unhide rows. But it didn't run after slecting
other item in Pivot Table.
 
Thanks Jacob.

After following your code, the marco didn't run after unhiding rows. But it
didn't run after selecting other items in pivot table.
 
Back
Top