Auto Open - Clear all filters
You sure they have a commandbar name macros?
Maybe their not on the same sheet as you and the selection is different.
How about just flying by and ignoring any errors.
Option Explicit
Sub Auto_Open()
Dim wks As Worksheet
Application.CommandBars("Macros").Visible = True
On Error Resume Next
For Each wks In ThisWorkbook.Worksheets
wks.ShowAllData
Next wks
On Error GoTo 0
End Sub
But this won't help if it's the commandbar that's the problem.
klm wrote:
I created a macro for an .xls stored on one of our network drives. The macro
is suposed to clear all filters upon opening the .xls However it only seems
to work on my machine. When my fellow associates open it, they get an error.
What am I doing wrong? (See macro below) I tried making it "Sub
Workbook_Auto_Open()" but then it didn't even work on my machine.
Sub Auto_Open()
'
' Auto_Open Macro
' Macro recorded 11/30/2005 by Kathy Miller
'
'
Application.CommandBars("Macros").Visible = True
Selection.AutoFilter
Selection.AutoFilter
End Sub
--
Dave Peterson
|