View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default question about toolbar corruption

I had never peeked!

But I just did. I didn't see anything that looked vaguely like it was mine
(xl2002).

But in earlier versions of excel (xl2002 seems to behave better based on posts
I've read), that was a way that bloated the .xlb file--just adding items to the
toolbars contributed to the bloat, even if you deleted them later.

I started backing up my .xlb toolbar in xl97 and won't let it xl (any version!)
bloat it. I just copy my backup into the real folder whenever I want (a few
times a week/day, when I'm experimenting in the newsgroups).

I don't think you can do anything to clean it--just wipe it out and revert to a
saved version.



Brian Murphy wrote:

I have an addin that adds a custom menu every time its opened, and removes
it when its closed. I've been doing this for quite a long time, and I'm
quite sure that under normal circumstances, the adding and removal of the
menu works like it should.

Here's my question.

When excel is closed, if I peek inside the xlb file and see the name of one
of my menu items, does this mean the toolbar has become corrupted to some
extent?

Is there any way to clean it other than reverting to an older or entirely
fresh copy of the xlb file?

Thanks,

Brian


--

Dave Peterson