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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
I was nearly right, name it Book.xlsx
Regards, 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
Still wrong, lets try again, save as a template named Book.xltx in the
XLSTART folder Regards, Peter T "Peter T" <peter_t@discussions wrote in message ... I was nearly right, name it Book.xlsx Regards, 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
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. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to change Excel, not just the current Workbook
Pre-existing workbooks will not be affected by your settings in xltx
template. Only new workbooks. Styles are saved with the workbook so you will have to change the style in the pre-existing workbooks. Gord Dibben MS Excel MVP On Thu, 5 Mar 2009 09:46:01 -0800, Brad E. wrote: 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. |
Reply |
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) |