| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Xcel worksheets
Hi All,
I want to protect and hide formulas for a whole array of cells in spreadsheet ... Is there a way of doing this but retaining the ability to apply the Autofilter (under 'Data' menu option)? Many thax, Don- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Xcel worksheets
First you must have autofilter enabled then when protecting the sheet, allow
"use autofilter" in options. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 06:13:01 -0700, Don wrote: Hi All, I want to protect and hide formulas for a whole array of cells in spreadsheet ... Is there a way of doing this but retaining the ability to apply the Autofilter (under 'Data' menu option)? Many thax, Don- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Xcel worksheets
Many thanks Gord! Worked a treat ;)!
"Gord Dibben" wrote: First you must have autofilter enabled then when protecting the sheet, allow "use autofilter" in options. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 06:13:01 -0700, Don wrote: Hi All, I want to protect and hide formulas for a whole array of cells in spreadsheet ... Is there a way of doing this but retaining the ability to apply the Autofilter (under 'Data' menu option)? Many thax, Don- . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protecting worksheets | Excel Worksheet Functions | |||
| Protecting Worksheets | Excel Discussion (Misc queries) | |||
| protecting worksheets | Excel Discussion (Misc queries) | |||
| Protecting worksheets | Excel Worksheet Functions | |||
| Protecting Worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
