Peter said:
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"
message
As for why i am loosing it, i have no clue. I don't have any problems
with Excel (2000).
It will be fine, and then sometimes when i open it, its all back to
default.
Oh, and i'm not running any code that will reset it to default.
Luckly i back up everything, so i always have one to copy back, which
always works ok.
Oh by the way .xlb is 1970kb.
This is the folder where it was, and i have put my back up in here
C:\Documents and Settings\MyName\Application Data\Microsoft\Excel
It looks like the Addin isn't a good solution, so i will just keep
doing what i am doing..
Thx very much for you expertise