AutoFilter settings in shared workbook

J

Jill

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
 
D

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
 
J

Jill

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top