+ Reply to Thread
Results 1 to 7 of 7

Data validation disappeared

  1. #1
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Data validation disappeared

    Hi! My Data validations has disappeared and doesnt show a list when you press in the cell. Any ideas on how to fix this?

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Data validation disappeared

    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

  3. #3
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Data validation disappeared

    The Drop down lists worked fine until today. I have "Display options for this workbook: For objects, show: All"

  4. #4
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Data validation disappeared

    It seems like the drop down menus disappears when I run a macro.

  5. #5
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Data validation disappeared

    How can I fix this??

  6. #6
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Data validation disappeared

    This is marked Solved? Is it still problem?

  7. #7
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Data validation disappeared

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Validation Drop Down list disappeared
    By Mile029 in forum Excel General
    Replies: 13
    Last Post: 03-22-2024, 11:04 AM
  2. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM
  3. [SOLVED] YIKES! All Validation functionality DISAPPEARED!
    By Stilla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2005, 06:15 PM
  4. Excel data completely disappeared - help !
    By cool4cats in forum Excel General
    Replies: 1
    Last Post: 09-25-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1