ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add macro to excel toolbar from worksheet (https://www.excelbanter.com/excel-programming/349363-add-macro-excel-toolbar-worksheet.html)

CurtH

Add macro to excel toolbar from worksheet
 
I want to add three macro from my workbook to the toolbar. So, I can use
them on any worksheet at any time. Is this possible and how?

Dave Peterson

Add macro to excel toolbar from worksheet
 
If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

CurtH wrote:

I want to add three macro from my workbook to the toolbar. So, I can use
them on any worksheet at any time. Is this possible and how?


--

Dave Peterson


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

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