Data Validation - In cell list drop down

G

Guest

Question for the MVPs out there.

I have an Excel [2000] Workbook that contains three cells with data
validation enabled.
The settings are to allow a "list" with the source manully entered. ie.
"George Smith,John Eagar, Mick Richard". The In-cell drop-down checkbox is
ticked, but the allow Ignore Blanks is not ticked.
The three dropdown lists work without a problem.

However, when I move the sheet to a new workbook, although the settings are
retained, the "in-cell dropdown" or combo box no longer works or becomes
disabled.
If you save the sheet, turn the cell dropdown off, save close, come back in,
the problem will still not fix itself. Can someone explain this bug and tell
me if there is a fix of patch for it.

Thanks for your assistance
Simon
 
G

Guest

Forgot to add,

If you copy the worksheet to the new workbook, instead of moving it, the
controls are still retained.

Thanks for your assistance
Simon
 

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