Hey guys probably easy fix but ive put so much work into this scoring sheet wondering if someone can have a look.

Whats happening is that i had 18 exams on a scoring sheet and everything was working as intended. then i was asked to add an additional exam on it, so i copied the worksheet tab and changed the necessary formulas to make sure everything added correctly. Then i went to use sort button(macro) and get run time error 1004) Unable to get the buttons property of the worksheet class

I will attach spreadsheet so you can see what im talking about, would greatly appreciate any help. Thank you

Attached Files

Scoresort added exam.xlsm (248.5 KB, 12 views)

Select your Exam19 sheet then on the Home ribbon in the Editing section, click Find & Select, click Selection Pane.
Is what shows the name the button on that sheet should have?
Also, all the sheet names have a space between Exam and the number except for 19.

You can also see the button name by right clicking on it and the name will appear above the row numbers.
This is where you can change the name.
Using that Selection Pane allows you to just click on another sheet to see the names they have.

got it, thanks you very much