Dropdown list multiple select not working in protected sheet

Hey,

I have a sheet with several multiple select dropdown lists and need to have the worksheet protected. I've been using the below code in ThisWorkbook:

Please Login or Register  to view this content.

But when I protect the worksheet the below code stops working, but it was working before I locked it.

Please Login or Register  to view this content.

Any help would be much appreciated!

Thanks
Oscar

You're doing the right thing by protecting the worksheets with the userinterfaceonly=true switch in the workbook open event.....however.....the reason you need to put this in the workbook open event is because Excel 'forgets' the userinterfaceonly switch whenever you open the workbook.

The reason it's not working is the sheets are already protected (locked).....and excel has forgotten about the userinterfaceonly switch, therefore, in order to be able to protect these sheets with the userinterfaceonly switch set to true you first need to unprotect them. ie, you can't protect a sheet that's already protected.

Add code to the worksheet open event to first unprotect all worksheets, then your code that protects all sheets with the userinterfaceonly switch will work correctly.

Hi BellyGas,

Thanks for getting back to me so quickly! When you say add code to the worksheet open event to first unprotect all worksheets, then my code. Are you able to share an example of what this would look like?

Thanks
Oscar

Please Login or Register  to view this content.