View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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.