+ Reply to Thread
Results 1 to 2 of 2

Drop-down lists - select multiple options with sheet protection

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    Bristol
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Drop-down lists - select multiple options with sheet protection

    Good evening,

    I have the following code in a spreadsheet which allows users to:
    • Insert their initials in column A and a date/time stamp appear in column B
    • Select multiple options from a drop-down list in column C.

    This has worked fine, until today when I've had to turn on sheet protection to stop users mucking up the formatting etc.

    The date stamp is still working, but I'm no longer able to select multiple options from the drop-down list due to the protection.

    Is there any way of allow this with protection still applied?

    Many thanks.

    HTML Code: 
    Last edited by jgroberts; 02-24-2019 at 09:05 PM.

  2. #2
    Registered User
    Join Date
    02-24-2019
    Location
    Bristol
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Re: Drop-down lists - select multiple options with sheet protection

    Bump if anyone would be able to help please?

    Thanks,

    James

+ 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. Help with making a drop down list in many cells that allows me to select multiple options
    By translatorinscotland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2016, 12:53 AM
  2. Replies: 8
    Last Post: 08-11-2016, 11:07 AM
  3. Select multiple options from drop down list
    By forestview in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2016, 01:42 PM
  4. Select multiple options from drop down list
    By nsprasad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2015, 05:30 AM
  5. Populating multiple drop down lists with different options
    By achdeekay in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2013, 08:17 PM
  6. Replies: 2
    Last Post: 04-23-2005, 12:06 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