W
watermt
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.
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.