| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep Data filtering functional when protectiong Worksheet
Good morning.
Is there any way to keep the data filtering function in tact while, at the same time, protecting various selected cells in a spreadsheet? I am using Windows 2000 and Office Excel 2000. Can this be done without the use of a special macro? I tried unchecking various combinations of the Protection, I.E. Objects,Contents,Scenarios, but I can only unlock all the cells or the data filtering becomes unusable also. Thanks Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which is Better / More Functional / Accurate | Excel Worksheet Functions | |||
| Excel 2007 Nearly Non Functional | Excel Discussion (Misc queries) | |||
| Filtering data and replace on to an new worksheet | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Filtering data from one worksheet based on another | Excel Discussion (Misc queries) | |||
![Phil C[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
