Macro - Refresh Multiple Protected Pivtos (on Multiple Sheets) Upon Workbook Opening

Hi,

I am having some really big trouble with a VBA code problem on an excel database of mine (I am pretty new to VBA writing so a dummies guide would be great).

I have a workbook with six separate worksheets each containing pivot tables running off the same data table.

Each sheet is password protected - If possible I would like to write a macro by where when the workbook is opened - the macro automatically runs - unprotects the sheets - refreshes all of the pivots - re-protects the sheets.

I have tried to write something through my own learning but what seems to happen is that once the macro has run, the data table isn't protected and therefore the cells can be edited which I don't want.

I want all of the sheets to be protected with the exception of a range of cells in the data table by where they can be edited (requested via a password)

I don't know how to write the code or where to put it.

Any quick responses and help would be hugely helpful and I would be eternally grateful.

I have the database to send if that is easier for anybody.

Thank you for all you time,

Luke

Any help at all would be so appreciated - really struggling with this.

Thanks,

Luke