View Single Post
 
Old 03-30-2015, 03:36 AM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote