power query

I need help with some code, i am using power query on a worksheet that is protected and the workbook is protected as well, i am traying to write a code that will refresh the power query for new information and i have this:

Please Login or Register  to view this content.

this dirent work because it say that the workbook is protected and cant refresh the power query table, so i did this:

Please Login or Register  to view this content.

this also did not work, it run the 10 sec showed the msgbox and then again the "cant refresh this workbook is protected".
anyone has a solution to this please?

Please Login or Register  to view this content.

this worked perfect, thank you.