#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rio
 
Posts: n/a
Default buttons?

years ago i made buttons to put on my tool bar that were just basically
macros but have forgotton how to do that. I wANTto make about 20 buttons cann
you help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Gill
 
Posts: n/a
Default buttons?

Hi Rio,

Go to View - Toolbars - Customize. Select the Commands tab and select
Macros in the Categories box. In the Commands box you will get two options -
Custom Menu Item and Custom Button. Drag 'Custom button' to the toolbar.

Then right click on your new button and select 'Assign Macro...' Choose the
macro that you want the button linked to and close the Customize box.

Michael

"rio" wrote:

years ago i made buttons to put on my tool bar that were just basically
macros but have forgotton how to do that. I wANTto make about 20 buttons cann
you help

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
Option Buttons coryrey Excel Discussion (Misc queries) 1 January 6th 06 03:49 PM
Can I make 2003 use the buttons icons of 2000? fabiospark Excel Discussion (Misc queries) 0 October 25th 05 09:07 AM
No Buttons to Control Subtotal Levels!?!? Levi Excel Discussion (Misc queries) 1 October 20th 05 07:31 PM
Using 'Option Buttons' Julian Excel Discussion (Misc queries) 3 August 17th 05 07:36 PM
Vanishing Control Toolbox Command Buttons Fritz24 Excel Discussion (Misc queries) 2 June 7th 05 01:39 PM


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

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

About Us

"It's about Microsoft Excel"