Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distributing Macros
I am very new to app programming in Excel. I have a macro which
creates a custom menu and toolbar. The toolbar uses gif files stored in a required folder on the user's local hard drive. I do not have the developer's tool for office. What is the best approach to distributing this to 20 users? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distributing Macros
If you must use custom images for the toolbar faces, then I suggest you
store them in a workbook and name them so code can refer to them directly. Place all of the code and save the workbook as a special Excel Addin. Here's a sample of the code that copies the custom image onto the toolbar face... wksToolBar.Shapes("NameOfCustomImage").CopyPicture ctlButton.PasteFace 'ctlButton = the commandbar control you want to place the image on You can them distribute the self-contained Addin. -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Carm" wrote in message om... I am very new to app programming in Excel. I have a macro which creates a custom menu and toolbar. The toolbar uses gif files stored in a required folder on the user's local hard drive. I do not have the developer's tool for office. What is the best approach to distributing this to 20 users? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
distributing days | Excel Worksheet Functions | |||
Distributing a Cell Value | Excel Worksheet Functions | |||
distributing numbers | Excel Discussion (Misc queries) | |||
preserving type library references when distributing macros | Excel Programming | |||
Distributing code | Excel Programming |