Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Saving a custom number format
On 8/27, I asked about getting a button for a custom number format into the
Quick Access toolbar in Excel 2007. Thank you to Bob and Roger for your replies. By right-clicking on Home Styles Cell Styles Number Format Comma and choosing Modify, one can modify the way the Home Number Comma Style button works. I am wondering if, once I modify the Comma Style button, I can have the button work with the new format EVERY time I am in Excel? Thank you, Brad E. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Saving a custom number format
if you put the code in the workbook_open event of personal.xls, that should
do it. -- __________________________________ HTH Bob "Brad E." wrote in message ... On 8/27, I asked about getting a button for a custom number format into the Quick Access toolbar in Excel 2007. Thank you to Bob and Roger for your replies. By right-clicking on Home Styles Cell Styles Number Format Comma and choosing Modify, one can modify the way the Home Number Comma Style button works. I am wondering if, once I modify the Comma Style button, I can have the button work with the new format EVERY time I am in Excel? Thank you, Brad E. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Saving a custom number format
How does one put the code in the "workbook_open event of personal.xls"? What
code is there, where do I find it? Where is the file "workbook_open event of personal.xls"? Thanks, Frustrated Excel Classic power user ================================ "Bob Phillips" wrote: if you put the code in the workbook_open event of personal.xls, that should do it. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
custom format saving | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
custom format & saving | Excel Discussion (Misc queries) |