Dashboard: "use pivot table" disables with macro|VBA & Macros|Excel Forum|My Online Training Hub

 Hello, and thanks in advance for any/all help and/or advice!  I have attached my dashboard. I am currently struggling with the protection feature. I have included a "click here" button with a macro for other users to refresh the data.  Within the macro, I wish to include the commands to unprotect and re-protect (with password).  Each time I try, when it re-protects it disables the slicers because the use pivot table and pivot chart and use auto filters become unchecked.   I am struggling with the correct wording/command (If/Then) to use to allow "use pivot table & pivot chart" and "Use auto filters".  (All information included is fake--no personal or company information is being shared).  I look forward to opinions and guidance.  Thank you!