Toolbar & custom buttons - gone!

R

redruthann

Hello - Sorry for the long post.
I am very upset - I have spent a lot of time (a lot) customizing my
Excel XP sp3 (WindowsXP sp2 - up to date)- New Toolbars with macros and
custom buttons (which take some time to create).

Today, like every other day, I open my finance workbook and was basically
devistated - all of my custom work is gone!! They were there last night when
I shut down - All I did yesterday after recording the day's finances, was to
copy many CDs onto my hard drive d: (I have a split hard drive) in order to
combine all onto
DVDs - I did not do anything that would affect my XL XP.

As Roger B. stated (below), my macros are still there, but not my custom
toolbars or buttons. I tried opening my other workbooks, as Joerg suggested:
If it's about custom icons associated with macros, try to run some of your
previous workbooks. Chances are that the icons are linked to your workbook
and they might appear only in certain workbooks.

....nothing. I did restart the computer (always first thing).

I wonder...I had opened a few worksheets from the old CDs to see what it
was, could this have affected the toolbars? Could this have changed my
personal startup workbook? I had some trouble with my startup sheet a while
ago - but since fixed it and has been working fine until now.

If I can find another startup workbook, do you think that my toolbars and
such would still be there?

Pleas Help - I'm desparate - it would take at least an entire day to
recreate everything.

Ruthann

Previous Post:

Subject: Re: Toolbar problems 8/31/2006 10:03 AM PST

By: Roger B. In: microsoft.public.excel.programming


Joerg, thanks for your helpful comments. This is looking more like mission
impossible which is what I expected. Ouch!
 
T

Tom Ogilvy

Toolbar customizations are stored in a file with an xlb extension. If you
can find this file and it isn't corrupted and hasn't been overwritten, then
you can open it like a workbook and it should restore your customizations.
If you can't then they are gone.

http://support.microsoft.com/kb/291074/en-us
Default toolbars and toolbar buttons seen instead of customizations in Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top