B
Brad E.
Hi, all,
I would prefer if the "Comma Style" button were set up differently for me
EVERY time I use Excel 2007.
By recording a macro, and going to Home > Styles > Cell Styles > Number
Format > (right-click on) Comma > Modify, then changing the format how I want
it, the following code was produced:
With ActiveWorkbook.Styles("Comma")
.IncludeNumber = True
.IncludeFont = False
.IncludeAlignment = False
.IncludeBorder = False
.IncludePatterns = False
.IncludeProtection = False
End With
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
Is there a way to have this code run every time I open Excel?
I have already attempted this, and there are 2 files in my XLSTART folder:
Book.xlsx
Book.xltx
I assume I will have to save a file to my XLSTART folder - but which format
should I use? and should I get rid of either of the two files which are
currently in there?
I would prefer if the "Comma Style" button were set up differently for me
EVERY time I use Excel 2007.
By recording a macro, and going to Home > Styles > Cell Styles > Number
Format > (right-click on) Comma > Modify, then changing the format how I want
it, the following code was produced:
With ActiveWorkbook.Styles("Comma")
.IncludeNumber = True
.IncludeFont = False
.IncludeAlignment = False
.IncludeBorder = False
.IncludePatterns = False
.IncludeProtection = False
End With
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
Is there a way to have this code run every time I open Excel?
I have already attempted this, and there are 2 files in my XLSTART folder:
Book.xlsx
Book.xltx
I assume I will have to save a file to my XLSTART folder - but which format
should I use? and should I get rid of either of the two files which are
currently in there?