Hi Guys,

Thanks for responding back. There are 500 worksheets in this workbook and
only two buttons on each sheet. However the contents on the spreadsheet is
changing and a quicker way to update this information is needed. I
appreciate your help.

"Mike H" wrote:

Hi,

Is there only one button on each of these 500 sheets? If there are more than
one how do we know which button to change the caption on?

Mike

"tkincaid" wrote:

I used commandbutton from the control toolbar toolbox, I want to edit the
text on the button, the problem is I have over 500 sheets to do this to, can
I run a macro to complete this task.