View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad E. Brad E. is offline
external usenet poster
 
Posts: 76
Default I want to change Excel, not just the current Workbook

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.