December 18, 2020
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!
November 1, 2018