From the course: Access 2019: Building Dashboards for Excel
Join today to access over 24,400 courses taught by industry experts.
Assign macros to buttons
From the course: Access 2019: Building Dashboards for Excel
Assign macros to buttons
- [Instructor] Now that we've built our macros that allow us to navigate, clear filters, and do common filters, let's assign them to buttons on the dashboard sheet. Remember we set our print area, and we've set our slicers not to run, so these buttons will not print when we run this scenario, so let's go to our Developer tab. In the Insert section, I want you to choose the Form Controls and choose the button. I'm going to go ahead and click one time on the sheet, and immediately it prompts me to assign the macro. I'll go ahead and choose Clear Filters. While it's still highlighted, I'm going to jump in there, change my text, highlight that, and type, clear all filters. Okay. Alright, then I'm going to right-click it, so I can get my handles back. And then size it. Alright, great, let me just test it real fast, so I'm going to just choose the help desk, and then choose Clear All Filters. Let's go do another one.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
