Hi! My Data validations has disappeared and doesnt show a list when you press in the cell. Any ideas on how to fix this?
Hi! My Data validations has disappeared and doesnt show a list when you press in the cell. Any ideas on how to fix this?
Do data validation settings appear correct? Do you have display of objects set for 'All' in Excel Options - Advanced?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
The Drop down lists worked fine until today. I have "Display options for this workbook: For objects, show: All"
It seems like the drop down menus disappears when I run a macro.
How can I fix this??
This is marked Solved? Is it still problem?
Yes it is solved, I managed to fix it. In my code I had written "delete all shapes" but I rewrote it and now the data validation isn't missing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks