How to change font style and size for the entire workbook using VBA?

[atavane]

Hi:


I am not talking about new workbooks. I get workbooks from other users with multiple worksheets ( more than 25) and each having different fonts. I would like to set the font and size same for all the worksheets in the workbook. It is tidious to do manually. Is there a way to do this using VBA. Any help here is appreciated.


Thanks

VJ

 

[Hui]

You Don't need VBA

You Can group the sheets, Select the left most sheet tab and Hold Shift and select the Right most sheet tab

Then on the current sheet

Ctrl A to select all cells

Apply the Font/Size

Ungroup by clicking on any individual Sheet Tab

 

[atavane]

Hui


Thanks a ton. That worked...