Hello,
I have a workbook that I don't want the users to be able to change anything of the format, columns, rows, etc. so I protected the worksheet.
I have a macro saved in the sheet itself and not as a module that would allow users to select more than one option in the data validation drop-down lists. When I protect the worksheet I am not able to select more than one entry from the drop-down list. Hence, the macro is not working.
See attached workbook for more information
My question is: How can I protect the worksheet and at the same time have the macro work so I can select more than one option.
thanks for your help
below is the code that allows multiple selection
Bookmarks