Protect/lock cells after user input

Still learning and appreciate all the help ... Have a worksheet that will be used multiple times. User will enter name and employee number only on the first instance that the worksheet is opened. Would like to protect that info automatically for further usage. Most of the worksheet is protected but some cells need to remain unlocked so the "whole" sheet protection will not work. How do I protect only specified cells, say F3, G3, H3, I3, after the user enters data thru an input box without changing any other protected cells on the sheet? New enough that I need specific help, please. Code for user input:

Please Login or Register  to view this content.

Thank you for all your help - you all make me look like a genius at work for the simplest of things! :-)

One way is to select the cells that you dont want locked - Not the cells that will hold the employee name & number

Format Cells > Protection > Remove Tick from Locked option

Then you can Protect & unprotect sheet as required

Another option is using a macro that allows only certain cells to be selected

As Mudraker says you need to use Sheet protection correctly.

First select all cells on the sheet by clicking the grey box -top left, the junction between between A & 1
Format menu -> Cells -> Protect & uncheck Locked.
Next select all cells for input & format them as Locked.
Add a password -> Tools menu -> Protection-> Protect sheet.

Then use this code

Please Login or Register  to view this content.