Hi there brilliant folks,
I am hoping there is a way to limit the options that appear in the filter dropdown menus. In one case, I would like to remove all default options (i.e. sort, filter by color, etc.) in the dropdown EXCEPT for the checkbox options...and I would like to remove a few of those too. For example, when users click the dropdown filter arrow, I would like for them to ONLY see checkbox options to reflect my data "Show all, Pri-1, Pri-2, Pri-3 (which means I need a way to exclude "(Blank)" which shows up by default due to some necessary divider rows in my spreadsheet)."

I am brand new to this macro business as of a few hours ago. Basically grabbed some geniuses code I found online to remove the filters from the columns that need not be filtered. That was lovely, but I don't know enough to now do this further enhancement I want.

Thanks for any advice you can offer.

Mindy