VBA code to apply format to all sheets

[hblbs]

Hi

I was wondering if anyone knew what code can be used to apply formats to all sheets in a workbook. For example, in each sheet I have to apply filters to column A:E, Auto fit columns and Freeze windows at Row 2. I do this manually to all sheets and there can be up to 30 sheets. Anyone know how this can be done in one go?

Thanks in advance.

 

[Legacy 320057]

Thanks Dave!