VBA Code to Refresh power Query Table unlock/lock worksheet

[Yecart77]

Hi All,

Hopefully and easy one to solve in the hands of experts.

With an unprotected worksheet I have data in Power Query that is presented in a table with a Slicer and a button set up with this macro assigned to refresh the table that works perfectly.

Sub RefreshQuery()

ThisWorkbook.Worksheets("Worksheet Name').ListObjects("Query Name").QueryTable.Refresh

End Sub

But I do want to protect the worksheet and still allow people do not have the protect worksheet password to

1. Use the Slicer
2. Be able to click on the button to refresh the table.

How can I modify the above macro to allow people to use the slicer and be able to click on the refresh button and table updates?

Thank you one and all, I appreciate the help.

Cheers,
Tracey

 

[ExcelToDAX]

By clicking the refresh button, you mean the Macro button you are putting on the sheet, not the actual Data > Refresh All button, correct?

 

[Yecart77]

By clicking the refresh button, you mean the Macro button you are putting on the sheet, not the actual Data > Refresh All button, correct?

Yes, I want to put a button above the table to refresh the table.