Use the WorksheetSelction Change event and check the target range....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Mustang" wrote:

Does anyone know how I can create a macro that will run each time the Page
selection changes in my Pivot Table to display a message box?

I basically want to remind them to copy a total amount to another sheet.

Many thanks