You will have to use VBA to do this. For each text box that you want to have locked, you will need to open the properties for the form, select the events tab and on the events tab, select On Load. Your code will need to then follow the format "me.textbox.enable = false" for each of the textboxes you wish to lock. BTW, how will you enter new data if these fields/controls (cells are in Excel) are locked. Will that be a need or is no new data entered?
Alan
Bookmarks