VBA - Refresh Pivot Table Data in Locked Worksheet

[CSSI-Justin]

Hello all. I have a worksheet which has several pivot tables on it and I have inserted a button to refresh all the data. It works great for the others in our office who are not familiar with Excel but one person almost lost the pivot table on me so I tried locking the worksheet. When I do, the button no longer refreshes (a little searching online indicates that the refresh data option is disabled when locked).

So what I'm trying to do with it now is rewrite the code to take the following steps

1.) Unlock worksheet
2.) Refresh all data
3.) Relock worksheet

As I am not well versed in VBA, I was hoping someone on here has already come across this and has a fix.

Thanks in advance!

[xlnitwit]

Hi,
Recording a macro should give you the code required for that...