Solved

Excel 2003 Visual Basic Runtime Error 1004

Posted on 2014-09-16
5
964 Views
Last Modified: 2014-09-22
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?
0
Comment
Question by:mrherndon
  • 2
  • 2
5 Comments
 

Author Comment

by:mrherndon
ID: 40327218
0
 
LVL 45

Expert Comment

by:aikimark
ID: 40328629
I didn't encounter any error.  What data are you entering into these cells?
0
 
LVL 10

Accepted Solution

by:
FamousMortimer earned 500 total points
ID: 40328799
Looks like you have to call Me.Unprotect Password:="pwd" after If Not blnUnlockedAllCells Then
0
 

Author Comment

by:mrherndon
ID: 40337149
Thanks, FamousMortimer.  Excellent advice.
0
 
LVL 10

Expert Comment

by:FamousMortimer
ID: 40337235
Glad to help, thanks for the grade!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question