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