Saving and Sending Custom Buttons

  • Thread starter Thread starter Jim Morris
  • Start date Start date
J

Jim Morris

I have created some custom buttons and linked them to VBA
code. When I save the Excel sheet and send it to others
the VBA code is delivered but not the custom tool bar
buttons. How do I save and send these buttons along with
the Excel file?
 
did you create the buttons on a custom toolbar and attach the toolbar to the
workbook?

That worked for me.
 
Jim,

Check out these sites

http://j-walk.com/ss/excel/tips/tip67.htm

Identifying FaceID Values for CommandBar Images





http://j-walk.com/ss/excel/tips/tip40.htm

Identifying CommandBar Images





http://j-walk.com/ss/excel/tips/tip90.htm

Create a Toolbar on the Fly





http://j-walk.com/ss/excel/tips/tip53.htm

Creating Custom Menus



All from John Walkenbach's site.





Some other places to look under "menus" in



http://www.mvps.org/dmcritchie/excel/xlindexl.htm



and in Stephen Bullen's web page for MVPs



http://www.bmsltd.co.uk/MVP/MVPPage.asp
 
Tools=>Customize

Toolbars Tab, click New

Leave the customize dialog open and select the second tab. Either drag
items from here to your toolbar, or drag your custom buttons from there
current location to your bar.

Now go back to the toolbars tab and click attach. This will allow you to
attach your new toolbar to the active workbook.
 
Back
Top