Register
Log In
Unanswered
Home
Dashboards
Power Query
Power Pivot
Excel
Word
Outlook
June 25, 2016
Offline
Hello,
I am wanting to make sure that filters are cleared from a specific table in my workbook when the workbook is opened.
This is what I have tried, but I get an error...
Private Sub Workbook_Open()
'Clear filter on the Orientation Log table
Worksheets("Sheet2").ListObjects("OrientationLog").ShowAllData
End Sub
Thank you for your assistance. 
See Answer
Dashboards
June 25, 2016
Offline
Hi give this a try
Private Sub Workbook_Open()
Worksheets("Sheet2").ListObjects("OrientationLog").AutoFilter.ShowAllData
End Sub
Answers Post
Dashboards
Power Query
Power Pivot
Excel
Word
Outlook
June 25, 2016
Offline
Hi SunnyKow,
Thank you for your post. I tried it, at first I got the error: "Run-time error '9': Subscript out of range".
Then I realized that I needed to replace the "Sheet2" with the name of my worksheet tab "Orientation Log" and then it worked!!! SO YAY!!
I appreciate the help! 🙂
Most Users Ever Online: 57
Currently Online: clark shao
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
