If your .xlb file is close to 2 meg in size, delete it and recreate it.
Then backup that newly created *.xlb file.
My toolbar file got as large as 400-500kb (IIRC). Then I saw some messages that
described their toolbars in the 10-20kb size.
I deleted mine, recreated it and it's about 16k.
You may have better luck after you do this.
Desert Piranha wrote:
Peter T Wrote:
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
Hi Peter,
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
--
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
--
Dave Peterson