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
Bookmarks