Auto Filter

[craig.jenkins]

Hi All,

Is there a way to use the auto filter when all cells on a spreadsheet are protected. It doesnt appear to work when cells are protected.

Cheers

Craig.

[VBA Noob]

Maybe link will help

http://www.bettersolutions.com/excel...E028820332.htm

When protecting sheet tick autofilter

VBA Noob

[craig.jenkins]

Thanks mate but I only have to option to protect

Contents
Objects
Scenarios

Any ideas?

Cheers

Craig.

[craig.jenkins]

Thanks mate but I only have to option to protect

Contents
Objects
Scenarios

Any ideas?

Cheers

Craig.

[craig.jenkins]

Sorted it,

Use the following link

http://office.microsoft.com/en-us/ex...982701033.aspx

[craig.jenkins]

Hi All,

I using this VBA code to protect a sheet to enable me to use the autofilter. This works great but I want to be able to do this in a shared workbook but for some reason this does not work. Any ideas?

Cheers

Craig.

Private Sub Workbook_Open()

Sheet1.Protect password:="monkey", DrawingObjects:=True, _
        contents:=True, Scenarios:=True, _
        userinterfaceonly:=True
    Sheet1.EnableAutoFilter = True
    
End Sub

[Ron Coderre]

You need to set up the AutoFilter BEFORE you protect the sheet. The protection will allow you to USE the AF...but not create one.

Remember to Check: Use AutoFilter...when engaging protection.

Does that help?