Unlock password protected sheet using a Macro

[rsilayan]

I have a code in a sheet that refreshes a pivot table, but I have the sheet password protected. What do I put in the code to unlock the sheet with the password, refresh the data, and re-lock the sheet using that same passowrd? Thanks in advance.

 

[VoG]

Try

Sheets("Sheet1").Unprotect password:="abc"
'
'code goes here
'
Sheets("Sheet1").Protect password:="abc"

 

[rsilayan]

Thank you, thank you, thank you! I worked perfectly!