Sheet("insertname here").Select throws runtime error

[Kemidan2014]

I am trying to troubleshoot a previous employees Macro powered Excel file that we as a group use alot.

I was able to get the password to the VBA Project to unlock it but for some reason a procedure we used religiously now throwing up a runtime error

The line of code it errors on is simply this
Sheets("Front Page").Select

i confirmed the Tab name and code line are the same

So why would it all of a sudden do this type of error on a simple Sheet select of an unprotected workbook?

 

[starl]

It's unusual to "Select" sheets, but anyway:
is the sheet visible? are you sure the sheet name is correct? have you tried running that specific line in the Immediate Window and if so, do you get the same error?
Try renaming the sheet (possible corruption).
Found a reference to enabling "AccessibilitycplAdmin 1.0 type admin" in Tools, Reference.. but I"m not sure what that library is or why it's needed.

 

[Kemidan2014]

I did confirm sheet name to the reference are match by copy pasting the name
Your right theres better ways i am going to try at declare the sheets and set them and change all the sheets that are getting selected using declarations so they are being treated as objects to see if that works