Hi Brad,

Yes. You would have to do it via vba though.

A few things,
1. Relabel the commandbutton to cmdshowsum, or keep the one you have but
don't forget to change all the references in the code.
2. I used worksheet1 for this example, if you are using a different one be
sure to change 1 to whatever
3. Right click the sheet tab, view code, and paste the following.

Private Sub cmdshowsum_Click()

cmdshowsum.Caption = "Showing Summary"

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

Dim csp As String
csp = "Click for Summary Pages"

With Worksheets(1)
cmdshowsum.Caption = csp
End With

End Sub


hth

BigPig