From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Create macros that clear filters

Create macros that clear filters

From the course: Access 2019: Building Dashboards for Excel

Start my 1-month free trial

Create macros that clear filters

“

- [Instructor] Now that we have our dashboard basically ready, it's a good idea to add some macros that will make it easier for our users to work with it. One of the easiest macros you can create is to clear a filter. So I'm on my Developer tab and one of the very first things I want to do is go ahead and set my filters up. So, I'll go ahead and filter for 2017, I'll choose the filter for Executive, and then here I'm just going to Control + Click some of these folks to just turn them off. Again, just want to make sure there's some form of filter on every slicer before I record and then I'll go to Record Macro. This'll be called Clear Filters. It's going to clear all filters. And then when I click Okay, it's recording. And I'll just record myself clearing the filters and then I'll stop recording. Okay, let's go test it. I'll choose Executive and I'll go to Macros and I'll run Clear Filters. Perfect. Now let me just…

Contents