Using an form control combobox on an interface protected workbook

[michelle 1]

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.

Please Login or Register  to view this content.

Thanking you for your help.

[Norie]

How are you populating the combobox?

Does it have a linked cell?

[michelle 1]

Hi Norie,

Thanks for replying. I am populating the combobox with data on a different worksheet, my combobox does have a linked cell which is Q8 and i am using this cell as a reference for graph data.