I want to change Excel, not just the current Workbook
Sorry that's not right at all, my memory must be playing tricks, will have a
look later
Peter T
"Peter T" <peter_t@discussions wrote in message
...
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.
|