Prev: Open TIF or MDI files in Excel
Next: Spreadsheet (version 1).xls: file format is not valid
From: Don on 1 Apr 2010 09:13
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-
From: Gord Dibben on 1 Apr 2010 10:13
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 <Don(a)discussions.microsoft.com>
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-

From: Don on 1 Apr 2010 11:08
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 <Don(a)discussions.microsoft.com>
> 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-
>
> .
>
 | 
Pages: 1
Prev: Open TIF or MDI files in Excel
Next: Spreadsheet (version 1).xls: file format is not valid