Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbars..?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbars..?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Toolbars..?
Thanx Gord - I'll do a search..? Excel2000.. 3 of Toolbars were created the ToolsCustomize way. 2 in Modules.. Are Obviously safe. It appears all the Macros are still in Personal.xls.. Just custom edited TbButtons (Faces) Vanished. Not the end of the world, Just an annoyance. Don't know why, they vanished. But that's a lesson learned. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... | 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. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
Custom Toolbars - keep dissappearing | Excel Discussion (Misc queries) | |||
Custom toolbars | Excel Discussion (Misc queries) | |||
Showing custom toolbars on one W/S only | Excel Discussion (Misc queries) | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) |