If you are using a macro to update you can set your protections then protect
the workbook/worksheet to enable them. Then add:

ActiveWorkbook.Unprotect Password:=""
ActiveSheet.Unprotect Password:=""

to the beginning of the update macro. Put your password in the ""'.

At the end of the macro add

ActiveWorkbook.Protect Password:=""
ActiveSheet.Protect Password:=""

again with your passord in the "".

Squeaky

"watermt" wrote:

I have a worksheet that is updated from an external data source. I also have
a VLOOKUP formula in my worksheet (allows users to select employee ID number
in a validation list) which after selecting populates their LName, FName and
MI from the external data source.

I want to be able to protect certain columns of data from the users (these
cells do not require the user to enter any data) but still allow external
data updates. What form of Protection (worksheet, workbook, or cell) do I
need to place on the worksheet? I will also be locking the "window" feature
so they cannot change the window sizing.