Apply the same Worksheet Event to specific sheets

[bnichols]

Hi, im trying to find a way to apply the same Worksheet Change and Worksheet Calculate event to all sheets if If ws.Name Like "Period*". Tried a few methods like adding it to thisworkbook, however with the calculate event, the index match and xlookup formulas in the sheets themselves keep triggering the code in the background, regardless if its active or if the active sheet is Name Like "Period*". The code is decenlty long and the sheets like period are identical and im just trying to avoid copying/pasting the same code 13x if I have to make an edit. Any help is appreciated

 

[Larry Haydn]

The worksheet_change() works whenever something changes within a worksheet.

To prevent this from triggering at every change, place this statement at the beginning of your calculate event:
Application.EnableEvents = False

Then at the end of the calculation code, add this statement:
Application.EnableEvents = False