| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button to send current excel workbook by email | Excel Discussion (Misc queries) | |||
| Running an Excel AddIn from Access in Current WorkBook....Help!!!! | Excel Programming | |||
| Change current directory to the directory that the workbook loads from! | Excel Programming | |||
| excel change default column sort to current selection | Excel Worksheet Functions | |||
| i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) | |||
Threaded Mode
