New toolbar button
Can i create a new toolbar button which will format a cell in a particular
style? I am trying to create a style similar to "Comma style" but without any decimal places. |
New toolbar button
why not create such a style and apply it in the normal way.
or create it an link it to a button Sub MyMacro() selection..Style = "MyComma" End Sub go to tools = customize command tab right window go to Macros left window, select custom button and drag it to a toolbar. right click on the button and select assign macro. assign the above macro. Make other modifications as desired close the customize dialog. -- Regards, Tom Ogilvy "attaboy" wrote: Can i create a new toolbar button which will format a cell in a particular style? I am trying to create a style similar to "Comma style" but without any decimal places. |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com