Style question

[abrown]

When you modify the default style for the Currency toolbar button does it save for you to use in future in the workbooks or does it just save in the file where you make the change?

 

[Te4t0n]

If you go format, styles and edit there and save it is saved in excel itself i thin k. so what you have done i imagine it would be the same

 

[abrown]

Actually it only saved in the file. Any idea how to save it to Excel so the styles apply to all of my files??

 

[Inchhigh]

Taken from excel help file.

Note Custom formats are saved with the workbook. To have Microsoft Excel always use a specific currency symbol, change the currency symbol selected in Regional Settings in Control Panel before you start Excel.

 

[kc.crow]

If you want to save a new style to the button, you need to create a macro that applies the style and save it to your personal macro workbook. Then assign the macro to the button. As long as you're on your PC, you it should be there at the application level as opposed to the file level.