Dropdown list disabled from 2000 to 2003

leroy221

New Member
Joined
Sep 16, 2006
Messages
1
I have a file that I created in Excel 2000 and am now trying to use it in 2003. The file has dropdown lists that are cell protected so that the list is the only valid choice and nothing else can be entered. The worksheet is also protected so no one can manipulate it. The file is available on a network so many people use it, but it only works correctly on the 2000 machines. All of the new machines on our network (2003) need the worksheets unprotected to input data into the cells. If they are not unprotected the following error occurs: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password."

Any suggestions as to how I can fix this?
Thanks!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hi Leroy,

If you are using dropdown lists, are those combos or validation lists?

With validation lists, the user is automatically prevented from entering anything *not* in the list. Under these circumstances (1) there is no need to protect those cells -- the validation handles it. (2) You can unlock the validation cells (select them then Tools > Protection > uncheck Locked). When you protect the worksheet again you should be OK.

By the way, is this set up as a shared workbook?

Denis
 

Forum statistics

Threads
1,141,221
Messages
5,705,100
Members
421,378
Latest member
CarlosDuran

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top