Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Custom toolbar problem saving new buttons | Excel Discussion (Misc queries) | |||
sending email using voting buttons | Excel Discussion (Misc queries) | |||
sending email using voting buttons | Excel Discussion (Misc queries) | |||
Have problem sending spreadsheet email and losing custom toolbar and macros | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming |