Re: Custom Toolbars Disappear

See in-line..........

Do you have code in Personal.xls that creates the toolbars

On 18 Mar 2007 15:40:01 -0700, "c mateland" <chuckmateland@xxxxxxxxx> wrote:

I'm using Excel 2003 sp3 with WinXP sp2.

My Excel11.xlb is 48 kb. Is that big?

I wouldn't consider it large.


I created the PERSONAL.XLS fresh upon loading Excel 2003. It wasn't
built in Excel 97 for sure. I don't see how Excel could have a problem
with the code because it's only macro is the well-known sort
worksheets routine I got from this group. That's all that's in it. And
my security is always set to medium.

Strange that Excel would disable Personal.xls. Excel should condiser
Personal.xls to trusted even if security is set on High or Very High.


It appears I've rebuilt my xlb file before. I'm showing a
Excel11OLD.xlb in the folder that I created back last year and let
Excel build a new one. Yet, I'm still having the problem. I have many
custom tools and bars in my xlb, and so it's a real time-consuming
difficult task to rebuild these tools from scratch. I've done it
before trying to work this problem out, but it still occurs, so I'm
afraid it'd be a waste of effort.

I'll just watch what happens now that I have it back,

When Personal.xls is not disabled what happens if you move it out of your
XLSTART folder?

but I'm very
curious why my tool settings and customizations disappear when Excel
disables my personal.xls? Why is that?

All I can think of is that you have code in Personal.xls that creates the
toolbar customizations.

Frankly, I could live without
my personal.xls, but NOT my tool customizations.

I don't even have a Personal.xls and none of my customizations disappear so
don't know what's going on with yours.

Keep eye on this thread. Someone might have a better idea than I have.


Gord

-Chuck


On Mar 17, 11:16 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
The "too large" referred to the Excelx.XLB file, not the Personal.xls.

What version of Excel are you running and when did you create Personal.xls?

In older versions..........before XL97.............. Excel had a menu editor and
customized toolbars and menus were stored in Personal.xls.

If it did not load, the customizations would not show up.

If this is the case, you could go to the trouble of converting but sounds like
you should just re-build Personal.xls and delete your current *.XLB file and
start over.

For conversion of the older menu editor setup you can use a Jim Rech add-in.

http://www.oaltd.co.uk/MVP/Default.htm

Look for Jim's RemoveMenus add-in.

As far as why does Excel periodically disable Personal.xls..............hard to
say but usually due to some code Excel doesn't like or your Macro Security is
set to "High"

If it loads most of the time I would rule out the Security issue.

Gord

On 17 Mar 2007 16:52:26 -0700, "c mateland" <chuckmatel...@xxxxxxxxx> wrote:



Thanks, Gord.

"It" is this issue, whatever is causing it to happen. I'm loosing my
toolbars and personal.xls from loading each time "it" happens. They're
obviously related somehow because they get nuked at the same time.

My Personal.xls is only 25kb. That's not real large, is it? And it
contained no auto_... macros. In fact it had only one simple macro.

I'm not on a network, just a stand alone desktop.

I did the Help>About MS> Excel>Disabled Items and, sure enough, I
found the Personal.xls there. It had a note stating Excel had trouble
starting so disabled it. I enabled it, and it loaded my personal.xls,
plus I got my toolbars back and all my menu settings. How are those
related to disabling my personal.xls?

What possibly could Excel be having a problem with to periodically
disable my personal.xls and my customizations? How can I prevent or
better manage that?

Thanks,
Chuck

On Mar 17, 5:31 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
Menu and Toolbar customizations are stored in your Excelx.xlb file

"x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003.

If it gets too large, it can become unstable.

Or perhaps if on a network, Excel is confused about where to store it.

Do a search for this file. There could be more than one *.xlb file so may have
to check all copies to see which is loading.

Usually stored in..................

C:\Documents and Settings\username\Application Data\Microsoft\Excel

When found, first rename the *.XLB file to *.OLD file. Note the size of this
file in kb.

Now close out Excel then re-open.

Make a few minor changes to a menu or toolbar then close Excel.

Does Excel create a new *.XLB file?

What is the size compared to the *.OLD file?

Reopen Excel. Have your changes stuck?

As far as Personal.xls being nuked by "it", have a look under Help>About MS
Excel>Disabled Items.

Perhaps Excel thought it was not nice and banished it to the bad dog box.

If found there, hit "enable" to restore.

Gord Dibben MS Excel MVP

On 17 Mar 2007 15:08:20 -0700, "c mateland" <chuckmatel...@xxxxxxxxx> wrote:

Periodically, I open Excel to find my custom toolbars are gone and no
longer in the Toolbars list. This has occured for a long time, but
it's really getting on my nerves now. I'm tired of rebuilding them.

Any advice on what could be causing this, how to prevent it or
otherwise deal with it?

What's the best way to backup my toolbars so at least I can get them
back?

Thanks,
Chuck- Hide quoted text -

- Show quoted text -


.