Macro buttons disappeared

[Patti]

When I opened Excel this morning, my many macro buttons were gone. The
external data toolbar was not selected, so I re-selected it, but the macro
buttons weren't there. Does anyone know how to get the buttons back, or do I
have to set them up again? Any ideas on why this happened?

[Dave Peterson]

I have no idea what happened to them.

But after you recreate them (manual effort???), make sure you make a backup of
the file that holds those customized toolbars.

Close excel
use windows start button|search
to find *.xlb
Search in hidden folders for hidden files, too.

(I'd delete all but the one you just created--check the creation date/time.)

And back that file up to a nice location.

So if, er, when it happens again, you can just take that backup version and
paste it into the correct folder (all with excel closed).

Patti wrote:
>
> When I opened Excel this morning, my many macro buttons were gone. The
> external data toolbar was not selected, so I re-selected it, but the macro
> buttons weren't there. Does anyone know how to get the buttons back, or do I
> have to set them up again? Any ideas on why this happened?

--

Dave Peterson

[Patti]

Thanks -- will do!

"Dave Peterson" wrote:

> I have no idea what happened to them.
>
> But after you recreate them (manual effort???), make sure you make a backup of
> the file that holds those customized toolbars.
>
> Close excel
> use windows start button|search
> to find *.xlb
> Search in hidden folders for hidden files, too.
>
> (I'd delete all but the one you just created--check the creation date/time.)
>
> And back that file up to a nice location.
>
> So if, er, when it happens again, you can just take that backup version and
> paste it into the correct folder (all with excel closed).
>
> Patti wrote:
> >
> > When I opened Excel this morning, my many macro buttons were gone. The
> > external data toolbar was not selected, so I re-selected it, but the macro
> > buttons weren't there. Does anyone know how to get the buttons back, or do I
> > have to set them up again? Any ideas on why this happened?
>
> --
>
> Dave Peterson
>