Problem with sheetname in a macro

[Bob Ully]

I have a macro that calls a sheetname. When the macro runs:

Sheets("Macros").Select

the macro stops; I get :

Run-time error '57121':
Application-defined or object-defined error

I checked for leading or lagging spaces in the sheetname. I tried renaming the sheet. I have the exact same code in 2 other sheets and they work fine. My office recently upgraded to a new version of excel, and I was converting older "active-x" buttons to "form-control" buttons.

Any suggestions ??? Thanks for your input .

Bob U.

 

[JLGWhiz]

Maybe you can do it like they recommend at this link:

Application Error 57121 on Worksheets("Sheet1") - Microsoft Community

 

[Jonmo1]

I can't duplicate that error in any way.
Is that the 'Actual' code, or just an example you typed up?

The only errors I can get are
'Subscript Out Of Range' <-- happens if sheet name is misspelled
Or
'Application-defined or Object-defined error' <-- happens if the sheet is hidden

You might check for Missing References in Tools - References

 

[Bob Ully]

Maybe you can do it like they recommend at this link:

Application Error 57121 on Worksheets("Sheet1") - Microsoft Community

I will try deleting the sheet and rebuilding. Thanks. Bob U.