Whichever *.xlb you click on will become the one that excel will save. If you
start excel normally (not by doubleclicking on the *.xlb file), you'll see that
excel kept the one that was in use when excel closed previously.

Don't give up on creating either the menu items or the toolbar on the fly.
You'll find that a small investment (30 minutes???) and you'll have something
you won't have to worry about until it's time to make more changes.

(I hope I didn't cause you too much pain!)

Terry wrote:

Help... I do not know if you will look this far back
but...
Which xlb do I click on the master on the server or the
one on the workstation. How does it know to update the
other??? I'm confused ... but have been working on it.
Thanks..
-----Original Message-----
First, for the personal.xls stuff.

Name one personal-1.xls and the other personal-2.xls
(so you can open them both up and copy paste to create a
new version
(personal-3.xls???).)

The next thing I would do is to give the users a nice
interface to the macros
(if it doesn't have one already).

I like the way John Walkenbach did it in his
menumaker.xls file.
You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

This adds some options to the worksheet menubar (pretty
easy and pretty good
looking!).

Now save that personal-3.xls as an addin:
terryUtils.xla

Store that on the network folder (keep the real copy for
you to update). Use
windows explorer to mark it readonly. And have both
users do:
tools|addins
and then point at that addin
(get rid of the personal.xls's that are now out of date.)

===
As for the *.xlb file, I'd just start with the one that
is closest to what I
want. Modify it slightly.

Close excel
find that newest *.xlb
copy it to a network drive.

If either of you want to "refresh" your own *.xlb file
with this master, just
close excel and double click on the *.xlb file. The
newer versions of excel are
smart enough to update the "private" *.xlb files with
this master file.

In fact, if I were doing this, I'd start from scratch and
rebuilt it to just the
icons I like. My *.xlb is always cluttered with stuff I
thought I'd use--but
don't.



Terry wrote:

We have 2 computers in the office. It started out that I
had copied the same personal.xls and Excel10.xlb on both
computers. However, got sloppy and now they are no
longer
the same. Is there a way of combining information from
both machines files from above?
Then the next step would be can these files be stored on
the server like I do the templates so they would be
shared
and not need to be copied from one computer to the
other?
Thanks for any help....

--

Dave Peterson
.


--

Dave Peterson