Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Saving .xlb file?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 17 Jan 2006 13:42 GMT
I copied my .xlb file from one computer to another from a CD.  Apparently,
that made the file read-only.  I keep trying to modify the toolbars on the
second computer, but the changes never stick.  And I can't open the .xlb
file -any time I try, it just opens Personal.xls.  How would I change the
.xlb from read-only so I can save it with my changes?

Ed
Dave Peterson - 17 Jan 2006 15:24 GMT
I like to find where excel stores the toolbar file before I put the transfered
version there.

I'd start excel and then tools|customize
create a new (dummy) toolbar.  Add an icon to it.

Now close excel and then use windows start|search to find that new *.xlb file.

If you find more than one, look the date/times and delete them all (or move them
somewhere else).  But keep track of the folder that held the current *.xlb file.

Then copy that *.xlb from the CD to that location using windows explorer.

Right click on it and choose properties.  Make sure it's not marked ReadOnly.

Then start up excel and see if it worked.

This technique works ok if you're staying with in the same version of excel--but
if you're upgrading, I'd make a note of the icons I liked and rebuild it from
scratch.

> I copied my .xlb file from one computer to another from a CD.  Apparently,
> that made the file read-only.  I keep trying to modify the toolbars on the
[quoted text clipped - 3 lines]
>
> Ed

Signature

Dave Peterson

Ed - 17 Jan 2006 15:47 GMT
Thanks, Dave.  I know I've got it in the right folder, because all my
toolbars show up.  I hadn't remembered about unchecking Read-Only from
Properties.  I'll try that and see if it works.

Ed

> I like to find where excel stores the toolbar file before I put the transfered
> version there.
[quoted text clipped - 24 lines]
> >
> > Ed
Dave Peterson - 17 Jan 2006 15:53 GMT
I'd still look for other *.xlb files and move/delete them.  I think they're
clutter and they can confuse me later when I want to get things done.

> Thanks, Dave.  I know I've got it in the right folder, because all my
> toolbars show up.  I hadn't remembered about unchecking Read-Only from
[quoted text clipped - 44 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.