+ Reply to Thread
Results 1 to 3 of 3

ComboBox not working when sheet is protected

  1. #1
    Registered User
    Join Date
    03-09-2019
    Location
    Manila
    MS-Off Ver
    2010
    Posts
    5

    ComboBox not working when sheet is protected

    Hello again, i have a problem with ComboBox, Column B (Item Description) has data validation that when double clicked the ComboBox will activate. (The purpose of this is i want my cell to have suggestions and auto complete), The problem is i need my sheet to be protected (this is a shared workbook via network by the way), and when sheet is protected the ComboBox don't activate. I tried to unchecked the Linkedcell(Column B) and the .Locked to true but none of them works,

    Hope someone help me with this.
    here's my sample file.
    Attached Files Attached Files
    Last edited by AliGW; 03-16-2019 at 03:37 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    4,830

    Re: ComboBox not working when sheet is protected

    It doesn't work because you're using a before double click event and protecting the workbook stops that happening as you cannot put the cell into edit mode.

    You could unprotect just the range the comboboxes are in.

    Just out of interest, what is the idea behind using a combobox rather than in cell data validation for the drop down list?

    BSB
    Last edited by AliGW; 03-16-2019 at 03:38 AM.
    Please show appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    03-09-2019
    Location
    Manila
    MS-Off Ver
    2010
    Posts
    5

    Re: ComboBox not working when sheet is protected

    Quote Originally Posted by BadlySpelledBuoy View Post
    It doesn't work because you're using a before double click event and protecting the workbook stops that happening as you cannot put the cell into edit mode.

    You could unprotect just the range the comboboxes are in.

    Just out of interest, what is the idea behind using a combobox rather than in cell data validation for the drop down list?

    BSB
    Thank you for your reply, What i really want is to have a auto complete or suggestions or what ever they call it, while typing in the item list, my purpose is to minimize the error of inputting wrong spelled item descriptions since my list has 2000 plus rows i think data validation not for this kind of list. and the other users have no experience in excel so i need to protect it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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