| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Protection
When I protect my worksheet, I need to only be able to filter through the
worksheet to only those 6 cells I gave Data Validation to. Can you please save me? -- new one |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Protection
Format Cells Dialog Box (Protection)
Protect worksheet , Then Select the cells that can be changed Click Format click cells click the protection tab on the protect cells dialog box Click the locked cells so the check mark is removed, this will unlock the selected cells so changes can be made to them click ok Click tools, protection and then click protect sheet, fill out the last dialog box by using the default options. Good Luck -- William<"M" "nhen5" wrote: When I protect my worksheet, I need to only be able to filter through the worksheet to only those 6 cells I gave Data Validation to. Can you please save me? -- new one |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
| protection of worksheet | Excel Discussion (Misc queries) | |||
| Worksheet Protection | Excel Worksheet Functions | |||
| Worksheet tab protection | Excel Discussion (Misc queries) | |||
Linear Mode
