How did you create the custom toolbars in Personal.xls?

Via code?

Or do you mean you created new Toolbars using ToolsCustomize and assigned
macros from Personal.xls to buttons on these toolbars?

xx is your version 9 is 2000, 10 is 2002, 11 is 2003

If the latter, these customizations would be saved in your Excexx.xlb file

Maybe you lost that file.

If so, Excel would revert to the default Excelxx.xlb file and you
customizations are gone.

Excellxx.xlb will be stored in your profile folder.

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

Do a search for *.xlb files.

You may be able to find the customized one.


Gord Dibben MS Excel MVP

On Mon, 19 Jan 2009 22:32:13 -0000, "Andrew"
wrote:

I had several Custom toolbars in Personal.XLS
and they have vanished..!

Spent ages customizing Buttons etc.

Any Ideas at all..?
Any Feedback would be appreciated.
A.