Excel 2003 - Protecting Cells but allowing external data updates


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.
 
Ad

Advertisements

S

Squeaky

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
 
W

watermt

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

Advertisements

S

Squeaky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top