+ Reply to Thread
Results 1 to 3 of 3

Drop down box unremovable, any solutions?

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    Helsinki, Finland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    Drop down box unremovable, any solutions?

    Hi!

    I have an extensive file working properly but one data validation drop box CAN NOT be removed. The icon is always visible, not just when the cell is selected as I would want it to be. I can't select the icon in developer mode, right click does nothing and all data validation is removed from the cell. It just shows an empty list when I left click on it. If I make a new data validation in the cell it works properly as long as I select the cell and don't click on the drop down icon, in which case it just shows that empty list. I tried clearing the cell, deleting the cell and that godforbidden icon is not disappearing! I am close to losing my mind with this, please help me!

    The original drop down list was made by data validation, not from control toolbox. I have no clue what could've happened here.

    -Rasmus

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Drop down box unremovable, any solutions?

    Hi,

    That sounds exactly like this issue to me: https://social.technet.microsoft.com...lf?forum=excel

  3. #3
    Registered User
    Join Date
    06-28-2016
    Location
    Helsinki, Finland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2

    Re: Drop down box unremovable, any solutions?

    THANK YOU! xlnitwit

    Good to know I'm not the only one!

    I'll mark your reply as a solution since this clearly is not something a user can do anything about.

    Thanks again, I tried to google this for an hour but didn't find that thread!

    EDIT: Can I mark this as resolved somehow? I'm new to this site...
    However if anyone else encounters this same problem check out that link xlnitwit posted.

    -Rasmus
    Last edited by RazMan86; 06-28-2016 at 04:59 AM.

+ 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. Unremovable watermarks in excel
    By SnilleMikke in forum Excel General
    Replies: 1
    Last Post: 03-18-2016, 10:15 AM
  2. Strange Unremovable Worksheet Objects in VBE
    By yay_excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2013, 01:49 PM
  3. unremovable '(blank)s' in Pivot table
    By George1970 in forum Excel General
    Replies: 4
    Last Post: 06-09-2012, 11:01 AM
  4. Replies: 1
    Last Post: 11-04-2010, 06:46 PM
  5. IF with 3 possible solutions
    By jomili in forum Excel General
    Replies: 6
    Last Post: 09-14-2010, 08:41 AM
  6. Unremovable cell's comment
    By satucha in forum Excel General
    Replies: 1
    Last Post: 10-26-2005, 10:05 AM
  7. vba solutions a.s.a.p please
    By RELWOD85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2005, 01:05 AM

Tags for this Thread

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