Refresh PT Problem

[mikeymay]

I have a number of pivot tables in different worksheets but all connected to the same data and data range.

All of these sheets are protected and upon a sheet being activates (Worksheet_Activate) the sheet is unprotected and the table in that sheet is refreshed.

This works perfectly well for one sheet when I only unprotect the active sheet but on all the other worksheets, I have to unprotect ALL worksheets that have a pivot table connected to the same data.

I can see that I need to unprotect all worksheets to update a pT but I can't work out why one of the worksheets doen't need all the other worksheets unprotecting.


TIA

 

[mikeymay]

Thanks RoryA!