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?

Hi,

Do you still have the problem, if you remove Objects from Tools
Protection Protect Sheet...?

Carim

Yes I do. I've even tried checking all the boxes to pretty much allow
anything and it still will not work. The way I have it set up is that
I select 1 of 3 dates and depending on the date selected, a different
set of data is displayed. I am able to use the drop down box and
select a date but that is when I get the message saying that the sheet
has to be unprotected for the results to be displayed.



Carim wrote:
> Hi,
>
> Do you still have the problem, if you remove Objects from Tools
> Protection Protect Sheet...?
>
> Carim

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

That did it. I had that row hidden and forgot all about the linked
cell. Thanks.


Dave Peterson wrote:
> 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