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.

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.

I'm using an external data source and pulling information from that source
using a VLOOKUP function.

"Squeaky" wrote:

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.

Hi watermt,

I think I'm understanding you correctly now.
Using the worksheet protection should be the one you need. Workbook
protection won't protect individual cells from being modified. Just unlock
the cells you want others to be able to modify. It sounds like you may have a
drop down box, so you will need to unlock the cell the box links to also.

Squeaky


"watermt" wrote:

I'm using an external data source and pulling information from that source
using a VLOOKUP function.

"Squeaky" wrote:

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.