formatting macro

[Mustafa]

When excel opens, it has a default font, no background
color and black font color... Than you have to change the
font, color or cell size, etc...

is there a simple macro which I can use to format the
whole sheet (or whole file) at once (within a shortcut
key)...
using with that procedure takes alot time....

also do you offer to use "personal.xls" file for all
useful macros?... or it does not make sense ?

Thank you very much

Mustafa

 

[JE McGimpsey]

Format a blank sheet the way you wish (# of sheet, colors, background
colors, etc.). Save as a Template. Use that template for future
workbooks.

If you want it to be the default template, save it in the XLStart
directory with the file name Book.xlt.