Develop This VBA To Refresh Multiple Rather Than Single Sheet

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).

Please Login or Register  to view this content.

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,

Luke

Hi luke.walker,

You can use the below code to repeat for each worksheet in workbook.

Please Login or Register  to view this content.

Where
1) SheetName = Name of the sheet you dont want to include for refresh.
2) In place of Do Something, write your code of Refresh() subroutine.



Regards,
Paresh J

Hi,

Check if this helps, I have not tested this.
But make sure all worksheets has same password.

Please Login or Register  to view this content.

Regards,
Paresh J