+ Reply to Thread
Results 1 to 3 of 3

Double Click to Edit Dropdown Text in Locked Sheet

  1. #1
    Registered User
    Join Date
    07-26-2016
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    2010
    Posts
    2

    Double Click to Edit Dropdown Text in Locked Sheet

    I have a dropdown that I want users to be able to edit by using the formula bar as well as double clicking where they want to edit text within the dropdown cell after a selection is made. Excel is allowing me to do this as long as the sheet is not protected. Once the sheet is protected (it will always be protected for the users) I can only make changes in the formula bar but it will not allow me to double click within the dropdown cell where I want to make changes.

  2. #2
    Forum Contributor
    Join Date
    08-25-2015
    Location
    Near Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    152

    Re: Double Click to Edit Dropdown Text in Locked Sheet

    What happens if, instead of protecting the entire sheet, you protect ALL BUT the cells you need to be able to edit?

  3. #3
    Registered User
    Join Date
    07-26-2016
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    2010
    Posts
    2

    Re: Double Click to Edit Dropdown Text in Locked Sheet

    Good point Candybg, I forgot to mention that the specific cells are not locked when I right click > Format Cells > Protection > Locked box is not checked

+ 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. Double click cell - copy data to new sheet - create a list from double clicking
    By kakky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-04-2015, 11:14 PM
  2. Changing cell properties with double click, then revert with another double click
    By mweber2525 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2014, 01:40 PM
  3. Double click row to return data to userform for edit then return back to sheet
    By MattRSJ in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-31-2014, 06:05 AM
  4. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  5. Double click Listbox to edit item
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 04:12 AM
  6. Replies: 7
    Last Post: 04-02-2012, 01:51 PM
  7. Replies: 0
    Last Post: 11-16-2005, 08:30 PM

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