AutoFilter settings in shared workbook

[Guest]

I'm using a shared, protected workbook, with AutoFilter enabled, that allows
users to make edits in certain columns. When users edit the workbook and save
it, their AutoFilter settings are being saved as well, even when the Filter
settings box is unchecked in the Share Workbook dialog box. When another user
opens the workbook, the first user's AutoFilter settings are displayed.

Is there any way to prevent the AutoFilter settings from being saved along
with each user's edited changes?

Thanks!

--Jill

 

[Dave Peterson]

Maybe you could just run a macro that shows all the rows when the workbook
opens?

Option Explicit
Sub auto_Open()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
With wks
If .FilterMode Then
.ShowAllData
End If
End With
Next wks
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

The macro works perfectly when the workbook is unshared and unprotected. It
also works when the workbook is shared and unprotected.

However, when I protect the workbook, I get the following error:

Run-time error '1004'
Method 'ShowAllData' of object '_Worksheet' failed

Is there any way to make the macro run without unprotecting the workbook?

Thanks!