font type for existing workbook

  • Thread starter Thread starter kaleb0521
  • Start date Start date
K

kaleb0521

How can i change the font type for a existing workbook, without goin
into each sheet one by one? I need it to be arial narrow and th
default is arial
 
Kaleb, [in Excel 2003] right-click any worksheet tab and select Select All
Sheets; press Ctrl+A to select all cells; change the font; right-click any
worksheet tab and select Ungroup Sheets.
 
You may want to consider changing the "Style" of the default "Normal Style."
Go to <Format> <Style> and modify the "Normal" style.

With ActiveWorkbook.Styles("Normal").Font
.Name = "Arial Narrow"
'...etc
End With
 
Back
Top