protect sheet blocks filter
 

i have specified a range as unlocked but when i run a macro to copy a sheet
then protect the destination sheet the autofilter function is disabled. can
i use a filter on an unlocked range in a protected sheet.


' unlock filter range
Range("W12:AL12").Select
Selection.Locked = False
Selection.FormulaHidden = False

' add autofilter
Range("W12:AL12").Select
Selection.AutoFilter

're protect data sheet
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True

're-protect test WB
ActiveWorkbook.Protect Structu=True, Windows:=False

protect sheet blocks filter
 

Hi Bob,

I have a feeling you will need to activate the autofilter.
The following snippet is from the Microsoft Help.

ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True

HTH

Steven


-----Original Message-----
i have specified a range as unlocked but when i run a
macro to copy a sheet
then protect the destination sheet the autofilter
function is disabled. can
i use a filter on an unlocked range in a protected sheet.


' unlock filter range
Range("W12:AL12").Select
Selection.Locked = False
Selection.FormulaHidden = False

' add autofilter
Range("W12:AL12").Select
Selection.AutoFilter

're protect data sheet
ActiveSheet.Protect DrawingObjects:=True,
Contents:=True,
Scenarios:=True

're-protect test WB
ActiveWorkbook.Protect Structu=True, Windows:=False


.

protect sheet blocks filter
 

thanks for the help
"Dave Peterson" wrote in message
...
And .enableautofilter is one of those properties that excel doesn't
remember
when you reopen the workbook. I like to put this in Auto_open (or
workbook_open) so that the worksheet is protected the way I want when I
open it.

Steven Revell wrote:

Hi Bob,

I have a feeling you will need to activate the autofilter.
The following snippet is from the Microsoft Help.

ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True

HTH

Steven

-----Original Message-----
i have specified a range as unlocked but when i run a
macro to copy a sheet
then protect the destination sheet the autofilter
function is disabled. can
i use a filter on an unlocked range in a protected sheet.


' unlock filter range
Range("W12:AL12").Select
Selection.Locked = False
Selection.FormulaHidden = False

' add autofilter
Range("W12:AL12").Select
Selection.AutoFilter

're protect data sheet
ActiveSheet.Protect DrawingObjects:=True,
Contents:=True,
Scenarios:=True

're-protect test WB
ActiveWorkbook.Protect Structu=True, Windows:=False


.


--

Dave Peterson