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) |