I want to change Excel, not just the current Workbook
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.
|