MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add command to toolbar


Posted by Karen on January 06, 2002 3:31 PM

Is there anyway to add a command that would be the equivalent of the comma command, but with zero decimals. I want to avoid a writing a macro since this command should appear in all workbooks, everytime excel is opened and I don't want the user to have to have another workbook running with the macro.

Is this possible?
Thanks


Posted by John on January 07, 2002 3:45 PM

If you just save the macro to the Personal Macro Workbook (personal.xls), instead of "This Workbook", it will be available to all workbooks whenever you start Excel.