Hi

I have protected my workbook as below but users are unable to use the combobox as it asks for a password, is there anything i can add to the code that will allow users to make a selection using the combobox.

Private Sub Workbook_Open()




Dim wSheet As Worksheet

    For Each wSheet In Worksheets

        wSheet.Protect Password:="Password", _
        UserInterFaceOnly:=True

Next wSheet
 
   
End Sub
Thanking you for your help.