#1   Report Post  
Pat
 
Posts: n/a
Default Network issue

Anyone know how I can have a custom toolbar I have created in Office 2003 on
one computer made available on a another computer using Office 2000. The
two computer are linked together on a home network

Thank you if you can help
Pat


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

It depends on how you created your custom toolbar.

If you did it manually (tools|customize), then these changes are stored in your
*.xlb file (use windows search to find the latest version). Then you can
replace the other pc's *.xlb file with your new copy. (Warning--I'm not sure if
xl2k and xl2003's xlb files are compatible. I do know that xl95 and xl97
weren't. Second warning--If I had a bunch of custom toolbars, I wouldn't want
you overwriting it with your favorites.)

If you've associated macros with these buttons, you'll want to move the workbook
and locate it in the same folder name--else you'll be reassigning the buttons to
the macros.

===
If you created the toolbar, but attached it to a workbook, just share the
workbook.

If you're going to do that, you'll want to read Jan Karel Pieterse's notes:
http://google.com/groups?threadm=083...0a% 40phx.gbl

===
I think the easiest/safest way is to build the toolbar on the fly (when the
workbook is opened) and delete it when you close the workbook.

Here's a shell that I use to build toolbars:
http://groups.google.com/groups?thre...5B41%40msn.com

Then you could just share that workbook with the other pc.



Pat wrote:

Anyone know how I can have a custom toolbar I have created in Office 2003 on
one computer made available on a another computer using Office 2000. The
two computer are linked together on a home network

Thank you if you can help
Pat


--

Dave Peterson
  #3   Report Post  
Pat
 
Posts: n/a
Default

Hi Dave,

Thank you for your reply,
I think the easiest/safest way is to build the toolbar on the fly (when
the
workbook is opened) and delete it when you close the workbook.

Here's a shell that I use to build toolbars:
http://groups.google.com/groups?thre...5B41%40msn.com


The link is broken with 'Not Found' returned. Is the link correct?

regards
Pat

"Dave Peterson" wrote in message
...
It depends on how you created your custom toolbar.

If you did it manually (tools|customize), then these changes are stored in
your
*.xlb file (use windows search to find the latest version). Then you can
replace the other pc's *.xlb file with your new copy. (Warning--I'm not
sure if
xl2k and xl2003's xlb files are compatible. I do know that xl95 and xl97
weren't. Second warning--If I had a bunch of custom toolbars, I wouldn't
want
you overwriting it with your favorites.)

If you've associated macros with these buttons, you'll want to move the
workbook
and locate it in the same folder name--else you'll be reassigning the
buttons to
the macros.

===
If you created the toolbar, but attached it to a workbook, just share the
workbook.

If you're going to do that, you'll want to read Jan Karel Pieterse's
notes:
http://google.com/groups?threadm=083...0a% 40phx.gbl

===
I think the easiest/safest way is to build the toolbar on the fly (when
the
workbook is opened) and delete it when you close the workbook.

Here's a shell that I use to build toolbars:
http://groups.google.com/groups?thre...5B41%40msn.com

Then you could just share that workbook with the other pc.



Pat wrote:

Anyone know how I can have a custom toolbar I have created in Office 2003
on
one computer made available on a another computer using Office 2000. The
two computer are linked together on a home network

Thank you if you can help
Pat


--

Dave Peterson



  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Google is doing stuff (the link used to work ok).

http://groups.google.co.uk/groups?th...5B41%40msn.com

searching google via the UK:
http://groups.google.co.uk/advanced_...ugroup=*excel*
gives the older non-beta layout, too



Pat wrote:

Hi Dave,

Thank you for your reply,
I think the easiest/safest way is to build the toolbar on the fly (when
the
workbook is opened) and delete it when you close the workbook.

Here's a shell that I use to build toolbars:
http://groups.google.com/groups?thre...5B41%40msn.com


The link is broken with 'Not Found' returned. Is the link correct?

regards
Pat

"Dave Peterson" wrote in message
...
It depends on how you created your custom toolbar.

If you did it manually (tools|customize), then these changes are stored in
your
*.xlb file (use windows search to find the latest version). Then you can
replace the other pc's *.xlb file with your new copy. (Warning--I'm not
sure if
xl2k and xl2003's xlb files are compatible. I do know that xl95 and xl97
weren't. Second warning--If I had a bunch of custom toolbars, I wouldn't
want
you overwriting it with your favorites.)

If you've associated macros with these buttons, you'll want to move the
workbook
and locate it in the same folder name--else you'll be reassigning the
buttons to
the macros.

===
If you created the toolbar, but attached it to a workbook, just share the
workbook.

If you're going to do that, you'll want to read Jan Karel Pieterse's
notes:
http://google.com/groups?threadm=083...0a% 40phx.gbl

===
I think the easiest/safest way is to build the toolbar on the fly (when
the
workbook is opened) and delete it when you close the workbook.

Here's a shell that I use to build toolbars:
http://groups.google.com/groups?thre...5B41%40msn.com

Then you could just share that workbook with the other pc.



Pat wrote:

Anyone know how I can have a custom toolbar I have created in Office 2003
on
one computer made available on a another computer using Office 2000. The
two computer are linked together on a home network

Thank you if you can help
Pat


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web query returns no result from internal network Harry C. Excel Discussion (Misc queries) 1 April 27th 05 10:51 PM
Saving to a network share without delete permssions SteveHoot Excel Discussion (Misc queries) 1 January 5th 05 09:50 PM
Autofill issue... nc0229 Excel Discussion (Misc queries) 0 December 13th 04 11:12 AM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 01:22 AM
addin loading issue howiefan Excel Discussion (Misc queries) 3 December 1st 04 11:10 PM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"