Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbar button | Excel Discussion (Misc queries) | |||
Toolbar button | Excel Discussion (Misc queries) | |||
button on toolbar | Excel Programming | |||
Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
Toolbar Button | Excel Programming |