Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 72
Default toolbar buttons to allocate VBA macro

under Excel 2007,
is it possible to add custom buttons (smileys) to allocate macros as it
could under Excel 2000 ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default toolbar buttons to allocate VBA macro

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm



Roland wrote:

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


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
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 ?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 8 June 1st 08 09:28 AM
Excel Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 0 May 17th 08 02:24 AM
Buttons in a toolbar Daddio_1962 Excel Discussion (Misc queries) 8 January 15th 08 04:50 AM
Missing Macro Buttons on Toolbar Parker Excel Discussion (Misc queries) 3 March 24th 06 03:01 PM
Reassigning macro locations for toolbar buttons dm59 Excel Discussion (Misc queries) 3 January 12th 06 05:58 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"