Protecting a sheet with a list box

A

ABYPFCS

I have a list box with a number of companies. I then use a vlookup formula to bring in the account information to the proper cells. It works perfectly, except that when I protect the sheet, it will not work

What am I missing

Al Bailey
 
F

Frank Kabel

Hi
whcih Excel version are you using?
In Excel 2003 (and I think also in Excel 2002) you can enable this in
the protection dialog

--
Regards
Frank Kabel
Frankfurt, Germany

ABYPFCS said:
I have a list box with a number of companies. I then use a vlookup
Click to expand...
formula to bring in the account information to the proper cells. It
works perfectly, except that when I protect the sheet, it will not
work.
 
D

Dave Peterson

My first guess is that you have a linked cell for that listbox.

And that link cell is locked. When the sheet is protected, that locked cell
can't be changed.

One suggestion is to unlock that cell. If you don't want to do that, maybe put
it on another worksheet hidden away somewhere.
 
A

Al Bailey

I am using Excel 2003. If I hide the data on another sheet, I would still have to include a link that I would want to protect on the main sheet.
 
D

Dave Peterson

Ah, but that cell would contain a formula pointing at that cell on the other
sheet. And formulas can evaluate freely in a locked cell on a protected sheet.
 
Top