Hi Kevin
Try something like this event macro
Right click sheet tab, left click View Code and paste this code into the white area.
Change "name of your macro" to the one you want to run (retain the quote marks)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Answer = InputBox("Do you want to print this page? Type YES OR NO")
If Answer = "YES" Then Application.Run "name of your macro"
End Sub
Regards
Derek