New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Multi-select drop down list stops working once I protect the worksheet

Macros, VBA, Excel Automation, etc.

Multi-select drop down list stops working once I protect the worksheet

Postby kaliog7 » Wed Jan 20, 2016 1:41 pm

I am having an issue with my drop down list which are multi select. When I protect the work sheet so that certain cells cannot be altered or accessed my multi list function stops working. It will only let me select one value from the drop down box but as soon as I unprotect the worksheet it lets me select multi values from my drop down list. Please help I have googled and asked many people but no one seems to have an answer.
Thank you,
K
  • 0

kaliog7
Rookie
 
Posts: 1
Joined: Jan 20, 2016
Reputation: 0
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 123 guests