Method #3 is the way I've been trying to go, but I haven't found a way yet to
link all of the users Excel files to automatically link to a common Excel11
file on a shared network drive.
Of course I can always manually place my custom Excel11 file in their
folders on the C: drive, but that would defeat the purpose of having one
toolbar file to maintain and update as time goes on and new users are added.
Do you know how I can find this "KB" article you referenced? It sounds like
this would be my best bet.
As I mentioned before, the best thing I could find was an old Excel 97
Microsoft help that told me to go into the registry to link to the toolbar
file, but unfortunately it didn't work.
"Dave Peterson" wrote:
#1. You could add built in commands to the toolbar if you wanted.
#2. There is code in the workbook that builds the toolbar each time the
workbook/addin is opened. And that same toolbar is destroyed when the
workbook/addin is closed.
So if you update the file and distribute it to your users--and they install it
in the correct (same) location, then there should be no problems.
#3. I've seen a KB article that describes how to use a network drive to hold
the toolbar file--instead of a local (probably C:) drive.
If you're creating a toolbar with a bunch of icons that you like -- and you can
destroy the user's toolbars, then you could just search for your excel11.xlb
(xl2003 toolbar file) and share it with them. Have them put it in the correct
location and their customized changes will be replaced with yours.
If your users don't care (and lots don't!), then this seems like a reasonable
approach--well, I've done it for others. But if your users care, I wouldn't do
it.
Eric wrote:
Thanks for clearing up how to fix the floating toolbar. What do I do If I
just want to share a custom toolbar with no macro at all?
Also, If I ever updated this add-in, would it be automatically changed in
excel or would the users need to remove it and reinstall the add-in? If
that's so I'd rather look for another way of sharing the toolbar.
Is there a way that you can go into Excel's registry to change it's path to
the toolbar file? That to me sounds like it would be the easiest way.
"Dave Peterson" wrote:
I don't understand what you mean by a macro button.
The code at Debra's site creates a toolbar with icons that can be clicked to run
the macros.
If you don't like it floating...
You can change this portion:
.Position = msoBarFloating
to
.Position = msoBarTop
or
.Position = msoBarBottom
Personally, I like to float it in the window. The user can move it to where
they want, but I figure that they'll notice that it was added!
Eric wrote:
Thank you for your replys,
I tried the instructions that were given but it only shows how to do it with
a macro button. How do I write the VBA code for a custom toolbar that is not
floating in addition to a macro button that is on the toolbar with regular
buttons?
"Gord Dibben" wrote:
Create the Toolbar through VBA code and make it available to all.
Steps...............
Open a new file and add the code for creating a Toolbar. See below for help.
Save the file as an add-in.
Place the add-in in a common folder and instruct all users to load that add-in
and keep it loaded.
For help on creating a Toolbar see Debra Dalgleish's site.
http://www.contextures.on.ca/xlToolbar02.html
Gord Dibben MS Excel MVP
On Thu, 17 Jul 2008 05:58:00 -0700, Eric wrote:
I need to share a custom toolbar on the network so that when multiple users
use a common terminal with Excel, the custom toolbar will appear. I would
prefer having a single custom toolbar file so that there is only one file to
update from time to time and to make sure that everyone's toolbar is
identical.
I have Excel 2003. I believe something has to be done with the registry but
what I tried so far using instructions from Excel 97 hasn't worked so I'm out
of options.
--
Dave Peterson
--
Dave Peterson