Excel 2003 Visual Basic Runtime Error 1004
Posted on 2014-09-16
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?