Excel Filter on Protected Sheet

I'm looking for an expert in Microsoft Excel, specifically Excel for Microsoft 365, who can enable and maintain the functionality of fthe filter and clear filter options within the ribbon on a protected sheet. My main goal is to clear all the filters at once using the clear filter option within the ribbon, even when the sheet is protected. **Requirements:** - The project involves a protected Excel sheet where the autofilter was active before protection was applied. However, the filter and clear filter options are now disabled in the ribbon, which is problematic for my data management needs. - The ideal candidate should be highly skilled in Excel for Microsoft 365, with a profound understanding of its protection features and how they can be configured to allow filtering without compromising data security. - Experience in VBA (Visual Basic for Applications) might be required since a custom solution or workaround might be necessary to achieve the desired functionality. - The solution should be straightforward for a user to apply and should not require removing the sheet's protection to filter the data. **Objective:** - Enable the filter and clear filter options within the ribbon on a protected Excel sheet. - Ensure the integrity and protection of the sheet while allowing sorting functionality. If you have the necessary expertise and are familiar with Excel's advanced protection and filtering capabilities, I invite you to bid on this project. Please share your previous experiences and how you propose to solve this challenge.