Appying a Macro to all sheets in a workbook at the same time.

[Ghostwheel]

I have a workbook with Sheets numbered T1 through T200, I'm using the following macro.
Option Explicit

Sub Worksheet_Activate()
    Sheets(Array("Sheet Format Template", "T1", "T2")).Select
End Sub

Sub Worksheet_Deactivate()
    ActiveSheet.Select
End Sub

Is there a way to include all the sheets in the work book starting with the letter T without listing all the sheets individually as above.

Thank you,

Eric

[arlu1201]

It will be good if you try and explain what you are trying to do.

[Ghostwheel]

arlu1201,

I'm using the Sheet Format Template page as a master to apply any changes to the format or layout to all the other T named sheets in the work book, So if I need to update the primary form layout I can do it with all the other sheets at the same time.

Eric

[ragavan.sridar1]

try this.

ActiveWorkbook.Sheets.Select

[Ghostwheel]

Raga,

That works somewhat, I moved my master sheet over 7 letters so the changes do not affect my information sheet as well as the rest of the sheets. So it gets me through the hurdle.

Thanks

Eric