+ 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
    9

    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, UK
    MS-Off Ver
    365
    Posts
    7,468

    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.

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

    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)

Similar Threads

  1. [SOLVED] VBA not working on protected Sheet
    By VisionSmart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2018, 09:35 PM
  2. VBA not working on protected Sheet - II
    By VisionSmart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2018, 10:17 AM
  3. Tabbing in a protected sheet into a combobox - Help! Please!
    By cabriggsy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2015, 06:14 PM
  4. Combobox Data Validation on Protected Sheet
    By medz80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2014, 01:40 AM
  5. ComboBox/Data Validation won't work when sheet is protected.
    By Butler82Paul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 11:38 AM
  6. Replies: 7
    Last Post: 08-06-2013, 02:23 PM
  7. Tab Key is not working when sheet is protected
    By anwitha in forum Excel General
    Replies: 1
    Last Post: 06-01-2012, 08:22 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