ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   buttons? (https://www.excelbanter.com/excel-worksheet-functions/69976-buttons.html)

rio

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

Michael Gill

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com