Hi Desert,

Wonder why are you losing your xlb once a week, occasionally occurs but not
that often.

But your xlb doesn't belong in your Startup folder, at least AFAIK. Perhaps
that's why you have problems. I'd suggest, with Excel closed, search for all
*.xlb files and rename say *.bak. Start and close Excel. Search *.xlb again
and you should find a new default xlb. Delete that and replace with a good
backup in same location and same name as the file you just deleted.

With code, say in an addin, can't directly replace your faulty xlb with your
backup while Excel is running. Best you could do manually or with code is to
reset default toolbars and merge (load) your backup. Or reset the toolbars
and recreate your custom menus etc with code.

Could write a simple *.vbs to replace faulty xlb with a backup when Excel is
closed.

Are you sure your backup is good, if more than 100kb even heavily customized
it probably isn't.

Regards,
Peter T

"Desert Piranha"
<Desert.Piranha.29dm2o_1150261804.1795@excelforu m-nospam.com wrote in
message news:Desert.Piranha.29dm2o_1150261804.1795@excelfo rum-nospam.com...

Hi all,

About once every week or two, i loose all my altered & custom toolbars,
etc., back to the default.
So i have to get my backup xlb and copy it back to the Excel STARTUP
folder,
which works but is a PITA.

Soooo i was thinking if i made the xlb into a Addin then this wouldn't
happen.

Are there problems associated with this??


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=551748