Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting...
I've searched previous questions and cannot find quiet what I'm looking for.
I've created a form for my workplace - an expense form that allows employees to turn in various expenses. I have the form set up where it has various validations (dates, text lengths, etc), check boxes (set to unhide cells when checked), drop down lists and conditional formatting. My conditional formatting is conditioned upon which option they choose in the drop down list (certain cells highlight when a topic is chosen - so the employee knows where to fill in). How do I go about in protecting this form? When they choose a topic in the drop down list and the cells that need to be filled in highlight - how do I protect it so they can't fill in the other cells? Is this possible? Also, is there a way where they can just tab to the cell that is highlighted, skipping the unhighlighted cells? Hope my questions makes sense... thanks for any help anyone can provide! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting...
how do I protect it so they can't fill in the other cells?
Your macro would have to lock the cells that you do not want to allow input in. And unlock those where you do. After that the user could press Tab to move among the cells that are unlocked (this assume worksheet protection is turned on). -- Jim "Mon" wrote in message ... | I've searched previous questions and cannot find quiet what I'm looking for. | I've created a form for my workplace - an expense form that allows employees | to turn in various expenses. I have the form set up where it has various | validations (dates, text lengths, etc), check boxes (set to unhide cells when | checked), drop down lists and conditional formatting. My conditional | formatting is conditioned upon which option they choose in the drop down list | (certain cells highlight when a topic is chosen - so the employee knows where | to fill in). | How do I go about in protecting this form? When they choose a topic in the | drop down list and the cells that need to be filled in highlight - how do I | protect it so they can't fill in the other cells? Is this possible? Also, | is there a way where they can just tab to the cell that is highlighted, | skipping the unhighlighted cells? | Hope my questions makes sense... | thanks for any help anyone can provide! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting...
And how would I go about in doing that?
"Jim Rech" wrote: how do I protect it so they can't fill in the other cells? Your macro would have to lock the cells that you do not want to allow input in. And unlock those where you do. After that the user could press Tab to move among the cells that are unlocked (this assume worksheet protection is turned on). -- Jim "Mon" wrote in message ... | I've searched previous questions and cannot find quiet what I'm looking for. | I've created a form for my workplace - an expense form that allows employees | to turn in various expenses. I have the form set up where it has various | validations (dates, text lengths, etc), check boxes (set to unhide cells when | checked), drop down lists and conditional formatting. My conditional | formatting is conditioned upon which option they choose in the drop down list | (certain cells highlight when a topic is chosen - so the employee knows where | to fill in). | How do I go about in protecting this form? When they choose a topic in the | drop down list and the cells that need to be filled in highlight - how do I | protect it so they can't fill in the other cells? Is this possible? Also, | is there a way where they can just tab to the cell that is highlighted, | skipping the unhighlighted cells? | Hope my questions makes sense... | thanks for any help anyone can provide! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock the Column without Protecting the Sheet | Excel Discussion (Misc queries) | |||
Leave list box unprotected while protecting worksheet | Excel Discussion (Misc queries) | |||
protecting multiple worksheets | Excel Discussion (Misc queries) | |||
Lock cells without protecting sheet? | Excel Worksheet Functions | |||
Protecting Workbooks in Excel 2003 | Excel Discussion (Misc queries) |