You didn't specify how to identify the field that needs to be locked so Graham made an assumption on what that field may have contained. You would most likely need to alter the code to fit your actual field content.
Another way may be to bookmark the field and then change the code to lock any fields contained in that bookmarked range.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|