Hello all,

I have a workbook which has 2 sheets in it. One has a large amount of source data and in the other sheet I've created a set of 10 pivot tables which is fed from the source data sheet. I wanted to have the pivot tables update based upon changes to the source data using a Macro/VBA and I've found that using "ThisWorkbook.RefreshAll" works like a charm. However, I'd now like the sheet with the pivot tables to be protected from changes after the data refreshes. I'm guessing there is a better code to use in Macros/VBA but I've not been able to put my finger on it after many many web searches. Does anyone know the best code to achieve this? If anyone here has the answer to this question I'd be most appreciative!

Best,
Jenn