Hi,
I tried searching the WWW for this with no luck. Here's my end goal: Unprotect a worksheet before a refresh when Ribbon > Data > Refresh/Refresh All is clicked.
I have a worksheet with a pivot table that is Protected/Unprotected depending on what user do in the sheet itself. I want to make...