Like the title says....
I want to change the text on a worksheet button when I activate the sheet.
I know how to do it in a dialog box but don't have a clue where to start.

In short, I have a list of projects in a column and have a button above the
column.

I have a cell that counts how many projects I list in a range.

I'd like to have the button say something like:
"Summarize X Projects"

where "X" is the count of the projects and gets updated with the correct
quantity whenever I add a project to the list.

Part of my problem is that I have no idea how to find out the name of the
button so I can call it so any resource explaining those kinds of things
would help.

Thanks,