Saving a custom number format


B

Brad E.

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.
 
Ad

Advertisements

B

Bob Phillips

if you put the code in the workbook_open event of personal.xls, that should
do it.
 
Ad

Advertisements

J

jmn13

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
================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top