Hi,

This can be done using VBA programming environment built in Microsoft Excel.
You can do this by knowing if there is a change event which has occured.
Preferably changing a image would be convinient than changing text button.

Challa Prabhu

"Brad" wrote:

Can you have two different texts on a button?

If the user clicks the button - I would like it to say - "Showing Summary"

If the user makes a change to the spreadsheet - I would like it to say -
"Click for Summary pages"