Saving and Sending Custom Buttons

[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?

 

[Tom Ogilvy]

did you create the buttons on a custom toolbar and attach the toolbar to the
workbook?

That worked for me.

 

[Jim Morris]

No - how do I create a custom tool bar and attach it to the workbook?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[steve]

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

 

[Tom Ogilvy]

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.