Hi,
The code below enables entire workbook protect/unprotect, however ultimately it refreshes a particular sheet (sheet 8 in this instance) when the relevant data table is edited.
I have 7 sheets (one is the data table and the other 6 house pivots that work off this data table). What I want to happen is for the code to enable the unprotect, refresh and protect of all the sheets exactly like it does for the current sheet 8 (I am simply new to this an am unsure of how to write the code to make the refresh happen for all sheets).
I have inserted the following code in the 'ThisWorkbook' section to allow for to sheet protection macro to work:Please Login or Register to view this content.
Along with the following code in the sheet 8 section to enable the refresh macro to work:Please Login or Register to view this content.
Thanks for all of your time,Please Login or Register to view this content.
Luke
Bookmarks