View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default New numbering button on toolbar

hi
record a macro performing the steps you just discribed. put a custom icon
button on the tool bar and assign the macro to it.
how? right click any tool bar, click customize. in the catagory window,
scroll down to macro. in the command window, drag the smiley face icon to a
place on the tool bar. at the bottom, click modify selection. here you can
assign the macro and change the icon if you wish.

Regard
FSt1

"Craig" wrote:

I would like to place a button (or two) on my toolbar that has a different
format than those that are already there. It is one that I can get to by:
Format, Cells, Number, etc.but I would like to skip these steps and get it
on the toolbar. Thanks...jcs