Did you link it to a locked cell on that protected sheet?

rwnelson wrote:

I am using a drop down arrow box with 3 different criteria for data to
be displayed. The problem is that it won't work if the sheet is
protected. Is there any code I can put in that will prevent cells from
being selected without protecting the sheet so that the form will work?

--

Dave Peterson