Results 1 to 3 of 3

ComboBox not working when sheet is protected

Threaded View

  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.

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