Sharing Custom Toolbars with other users

[CRB]

I would like to know how to share a custom toolbar I have created. The
toolbar consists of recorded macros and personalized icons.

Any help woukd be greatly appreciated!

 

[Jim Aksel [MVP]]

Tools/Organizer... you can copy your toolbar to your Global.mpt and then
give them a copy of your Global.mpt.

However, you will need to know where the Macros reside within the files. I
do that from the Visual Basic Editor... ALT+F11. In the upper left window
you will see a "tree" that contains various modules,we etc (once you expand
it). You can right click on any module, form, etc. and click Export to an
external file.

To import into a new file, ALT+F11 (in the new file) and then File/Import...

 

[Gérard Ducouret]

Hello CRB,

By default, the tool bars are saved in the GLOBAL.MPT file. You can also
save the VBA modules in this GLOBAL.MPT file (Tools / Organizer) then share
this GLOBAL.MPT file : make a search to find it on your DD (it is in a
\1033\ directory for the english version and copy it on all the PCs, in the
same place.
On the contrary, you can copy the tool bar in the .mpp file which already
contains the BVA modules, and copy this mpp file on all the PCs. On each PC,
go to File / Organizer to move the tool bar in the local GLOBAL.MPT file.
Hope this helps,

Gérard Ducouret

 

[CRB]

Jim,


The toolbar is in the Global.MPT. BUt I am not sure how to give another
user a copy of my Global.MPT. When I go to visual basic editior there is not
a tree to click on.
I have 5-6 templates all set up with my toolbar and they are all on the
network. I am just not sure how to make my toolbar visable for other users.

 

[CRB]

Gerard,
I think I have tried that already, except for the module portion. When I go
to the organizer and look at the modules there is not one named VBA or BVA.
Not sure what to do from here .

Thank you,

 

[Gérard Ducouret]

CRB,
The VBA modules are named as you (or your developer) named them in the VBA
Editor....
Press ALT+F11 to switch in the VBA Editor and look at all the VBA modules
created in your project file and/or in your Global.mpt file.
Hope this helps,


Gérard Ducouret