autofilter problem in Mac, but works in Windows, Excel 2003

[Curran]

I work in Excel 2003 (Windows) and have set up an autofilter and password
protection. Autofilter works a treat, no problems. But when this same file is
opened on a Mac, the autofilter is inoperable. Any ideas? It does work if
the password protection is removed, but I want to leave it on.

 

[Dave Peterson]

xl2003 has an option to allow autofilter when you protect the worksheet. I'm
not sure if the version you're using on the Mac supports it.

xl2002 was the first version of windows excel to have this. In earlier
versions, you could use a macro.

If you already have the outline/subtotals/autofilter applied, you can protect
the worksheet in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
'.EnableOutlining = True
.EnableAutoFilter = True
If .FilterMode Then
.ShowAllData
End If
End With
End Sub

It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet, but that
won't help when you're filtering via code.)

====

If this doesn't help, you may want to post your question here:
news://msnews.microsoft.com/microsoft.public.mac.office.excel
if you don't get a good response.