Did you save as Book.xltx

For testing, colour format some cell in the saved Bookxltx, each time you
open a new book you should see your coloured cell. Note this only works for
new workbooks.

If you want all your old workbooks to include the modified style you'll need
to add it to each workbook as a one-off operation. Of course that can be
done programmatically, eg as a batch process open all files in a folder,
amend the built in style, save and close.

Regards,
Peter T

"Brad E." wrote in message
...
Still not there...
I have changed the "Comma Style" button by going he
Home Styles Cell Styles Comma (right-click) Modify

I have saved this Workbook as an .xlsx and as an .xltx in the XLSTART
folder, deleting any other files which were in the folder. I don't see
any
difference whether using xlsx or xltx. However, in each case, when I open
a
pre-existing workbook, the button works as Microsoft's default setup.
--
TIA, Brad E.


"Peter T" wrote:

Our posts crossed, I suspect my suggestion as quoted below merely opens
the
wb a single time, see my other post and save as a template named
Book.xltx
in the start folder (note, without the "1" in the name)

Sorry for the confusion,
Peter T
..
"Brad E." wrote in message
...
Thanks, Peter, it works great for all new workbooks.

Now, do you know if there is a way to make that button act the same for
all
workbooks? When I open an old workbook, and select a (pre-filled) cell
to
change to My comma style, it still uses the MS Comma Style (with 2
decimals).
--
TIA, Brad E.


"Peter T" wrote:

In a new workbook amend the Comma style as you want. Save the workbook
with
no code in the XLSTART folder as a normal workbook named Book1.xlsx
(or
in
whatever format you prefer), note do not save as a template, no code
required.

This should act as the template for new workbooks.

Regards,
Peter T


"Brad E." wrote in message
...
In my XLSTART folder, I have saved an .xltm file, where a single
line
in
the
Workbook_Open event reads:
ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0"
When I open another workbook, and push the "Comma" button, I get 2
decimals
for the cell(s). How can I make my "Comma" button ALWAYS display in
the
"#,##0" format?
--
TIA, Brad E.