Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
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?
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?