Macro to search through button texts and replace

I have accidentally labelled a button (form control, rather than activeX) wrong and duplicated the sheet over 50 times within the same workbook.

I need a macro to search through all sheets and adjust the name. I have tried doing this using a few methods and to no avail.

Hope someone can help.

I have managed to create a code to rename button1 but I need to search for any button which has text "ABC" on it within the entire workbook.
Anyone have any thoughts?

Please Login or Register  to view this content.

Brilliant, thanks very much!