Protecting Xcel worksheets

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

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-
 
First you must have autofilter enabled then when protecting the sheet, allow
"use autofilter" in options.


Gord Dibben MS Excel MVP
 
Many thanks Gord! Worked a treat ;)!

Gord Dibben said:
First you must have autofilter enabled then when protecting the sheet, allow
"use autofilter" in options.


Gord Dibben MS Excel MVP



.
Click to expand...
 
Back
Top