Hi thanks for your speedy reply.

My knowledge of VB is minimal. Can you give me a bit more guidance as to
what to put in the code please. I am a bit lost here sorry.

"Jacob Skaria" wrote:

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