ExcelBanter - workbook fonts

thank you! that was amazingly easy :)

"Gord Dibben" wrote:

Select sheet1.

Right-click on that sheet tab and "select all sheets"

CTRL + a to select all cells.

Change the font on sheet1 and will be done to all sheets.

DO NOT FORGET to ungroup the sheet after you're done.

Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 16:25:02 -0800, Icehearted
wrote:

Is there a piece of code someone could give me to make all my fonts in a
workbook the same? this workbook has about 20 sheets and i don't want to go
in and manually do font changes.

any help is kindly appreciated.

.