Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell protection problem
Hi,
Do you still have the problem, if you remove Objects from Tools Protection Protect Sheet...? Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell protection problem | Excel Programming | |||
VB protection problem | Excel Programming | |||
Protection Problem | Excel Discussion (Misc queries) | |||
Cell protection problem | Excel Programming |