Cell protection problem
 

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?

Cell protection problem
 

Hi,

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

Carim

Cell protection problem
 

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

Cell protection problem
 

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

Cell protection problem
 

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