View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
klm[_2_] klm[_2_] is offline
external usenet poster
 
Posts: 8
Default Auto Open - Clear all filters

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