Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Clear All Filters | Excel Discussion (Misc queries) | |||
How to save & reapply a set of excel filters after clear | Excel Discussion (Misc queries) | |||
VB to clear any filters when closing a spreadsheet | Excel Discussion (Misc queries) | |||
How to clear all filters in worksheet for all columns | Excel Discussion (Misc queries) | |||
Clear Auto Filter on Close (or open) | Excel Discussion (Misc queries) |