Saving and Sending Custom Buttons
 

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?

Saving and Sending Custom Buttons
 

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

That worked for me.

--
Regards,
Tom Ogilvy


Jim Morris wrote in message
...
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?

Saving and Sending Custom Buttons
 

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!

Saving and Sending Custom Buttons
 

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



--
sb
"Jim Morris" wrote in message
...
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!

Saving and Sending Custom Buttons
 

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.

--
Regards,
Tom Ogilvy

Jim Morris wrote in message
...
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!