ExcelBanter - Protecting Xcel worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protecting Xcel worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/260437-protecting-xcel-worksheets.html)

Don

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-

Gord Dibben

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-

Don

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-

.

All times are GMT +1. The time now is 10:14 PM.