mrherndon
asked on
Excel 2003 Visual Basic Runtime Error 1004
Attached is a spreadsheet with Visual Basic subroutines for automatically advancing focus to certain cells, capturing current time stamps after certain cell entry, and then locking time stamp cells from edit.
The sheet was developed from within Excel 2010 and seems to work fine inside that environment.
However, when running inside Excel 2003, it returns Runtime Error 1004, referencing inability to execute the Lock functions of the subroutine.
I really need some help reviewing the code here and eliminating the runtime error. Could someone help?
The sheet was developed from within Excel 2010 and seems to work fine inside that environment.
However, when running inside Excel 2003, it returns Runtime Error 1004, referencing inability to execute the Lock functions of the subroutine.
I really need some help reviewing the code here and eliminating the runtime error. Could someone help?
I didn't encounter any error. What data are you entering into these cells?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, FamousMortimer. Excellent advice.
Glad to help, thanks for the grade!
ASKER
FirstAid.xls