New Drop-down lists failing

M

me_mywhy

Hi, I'm working on Excel 2003, in a workbook with macros, radio buttons
etc. I've been trying to add a drop-down list using Data>Validation.
The validation info gets registered (only the data entered is a valid
input) but the drop-down list is not displayed (no arrow). Performing
the same procedure in a new spreadsheet on same workbook is successful
and drop-down arrow is displayed. Can anybody help me troubleshoot the
problem? What should I check?
Thanks
 
G

Gord Dibben

It is possible you have Tools>Options>View>Objects>Hide all selected.

This is a workbook only setting so does not apply across all workbooks.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Drop down list from index/match formula 1
Drop-down list and error message 1
Restrict Choice in Shared WB (drop down alternative)? 0
Drop down list hyperlink 4
Drop-down Lists 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Data Validation - Drop down when cell is blank 1
Drop-down lists 3

Top