Hi All,

I recently designed a macros that unprotected all sheets within my workbook - refreshed all pivot tables within the workbook (in case of recently added information into a data table) then re-protected the sheets.

The macros that you can see below was working absolutely fine until recently I made a couple of formatting changes which has now caused the following errors upon opening and clicking on worksheets:

Upon opening - 'Reference Is Not Valid'

Upon clicking worksheets - Runtime error 1004 - Reference is not valid' (when I click DEBUG it highlights the area you can see within the below macros).

Does anyone have a solution?

Thanks

Luke

Please Login or Register  to view this content.