Hello! I have been a lurker around these boards for a while and all the information has helped me tremendously. I have a project at work which involves training schedules for employees.

Right now i have 5 major filters for the reports 1) Complete/Upcoming 2) Due 3) Due Soon 4) Enrolled 5) Overdue. There options are on a master page with Form Control checkboxes. They do not have anything yet in the code.

I have a second spreadsheet which already has a pivot table set up with the report filter option which should change based on which checkboxes get selected. The end goal is to hide the filters and lock the sheets and allow the user control only from the master sheet as to avoid anyone creating any discrepancies.

I am looking for some guidance or if anyone has any code that I can use to make some of this work.

Thank you very much!