+ Reply to Thread
Results 1 to 2 of 2

Dynamic Drop Down list locked by Edit Objects in protected sheet

  1. #1
    Registered User
    Join Date
    08-23-2019
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    28

    Dynamic Drop Down list locked by Edit Objects in protected sheet

    Hi All,

    I have a dynamic drop down list which is not allowing me to change the contents when the sheet is protected. The cells are not locked on the sheet. If I check 'Edit Objects' on the sheet protection the cells are editable, when I uncheck 'Edit Objects' I am unable to get a cursor in the cell. The cells are set as a Data Validation type with source =Drop_Down_List.

    I have included two screen shots. Picture 1 is with 'Edit Objects' enabled. I have typed cair in the cell and my dynamic drop down list is displayed. Picture 2 is with 'Edit Objects' deselected, when i click on the cell the cursor changes to a hand and I see the entire list (over 7000 lines) but I am unable to type in the cell to activate the dynamic drop down list.

    Why is a dynamic drop down list being treated as an 'Object'?
    Attached Images Attached Images
    Last edited by Kestrel Aviation; 07-29-2020 at 02:01 AM.

  2. #2
    Registered User
    Join Date
    08-23-2019
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    28

    Re: Dynamic Drop Down list locked by Edit Objects in protected sheet

    Hi All,

    Sorted it myself. Replaced my pictures and text boxes (With attached Macro's) with ActiveX Controls. Now my drop down list works and controls are locked with Edit Objects enabled.

+ 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. Edit existing marco to unlock protect sheet, remove set criteria and re protect sheet
    By summer2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2013, 09:29 AM
  2. Protect sheet and edit Objects
    By FrankD10 in forum Excel General
    Replies: 3
    Last Post: 08-06-2012, 04:02 PM
  3. Protected Sheet Allow Edit Objects
    By jonhfl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2011, 10:38 AM
  4. Code to Protect Sheet Allowing Format Rows & Edit Objects
    By Kristine T. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2009, 11:47 PM
  5. Protect Sheet Allowing Users to Format Rows/Edit Objects?
    By Kristine T. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2009, 04:38 PM
  6. Protect Sheet>Edit Objects except textbox
    By tianah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2009, 12:28 AM
  7. [SOLVED] Locked cells with Protect Sheet.
    By ness in forum Excel General
    Replies: 2
    Last Post: 06-13-2006, 02:55 PM

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