View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default toolbar buttons to allocate VBA macro

Hi,

Yes. First create the macro. Then choose Office Button, Excel Options,
Customize, and from the first drop down at the top (Choose commands from)
pick Macros. Locate your macros and move it to the right by double-click it.
Then select it on the right and click Modify.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Roland" wrote:

under Excel 2007,
is it possible to add custom buttons (smileys) to allocate macros as it
could under Excel 2000 ?