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

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
.

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
.

First, Sorry.

I thought that your customizations to the toolbar would have been based on
built-in options (under tools|customize).

I didn't guess that you had macros assigned to customized buttons.

But to make life really easier, it would be worth the extra effort to either
assign the macros to the buttons each time the workbook opens (and kill the
toolbar when the workbook closes).

If you don't do this, it's really gonna become a pain when the workbook/addin
moves to a different location. Your macro assignments could be still pointing
to the old location--not the new location.

John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use.

If you really want a toolbar, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)

Don't panic!



Terry wrote:

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
.


--

Dave Peterson

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