Thank you. I am most appreciative of you taking time to
answer. In admiration of all that you know.
I double clicked on xlb and lost my menu connections to my
macros??
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
.