Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
i have a problem i have made a custom toolbar and some buttons on it then i
assign macros to the buttons when i reinstalled office 2003 the custorm toolbar disappeared i have read in form that save the file in xlb format but when i save or export file as personal.xlb there is no option of xlb or how can i export or save as personal.xlb what i do regards |
#2
![]() |
|||
|
|||
![]()
A .xlb extension indicates a Toolbar file, but, AFAIK, it is created by the
program when you customize toolbars/menus. You might want to check out the Help Topic "Use custom toolbars from earlier Excel versions" Make backup copies of this file any time you do any customizing so you can copy it back after a reinstall of the program. Otherwise, the customization you do may be lost if you re-install the program. If using Excel '03 you can also Attach a custom toolbar to a workbook file. Not sure if '02 & earlier support this feature. 1) Open the workbook to which you want to attach a toolbar. 2) On the Tools menu, click Customize, and then click the Toolbars tab. 3)Click Attach. 4) Click the custom toolbar you want to attach, and then click Copy. Note Be sure to save the workbook after attaching a toolbar. You might want to consider creating a file just for the purpose of attaching all of your custom menus & toolbars to it, keep it in a safe place. Hope this is useful |:) "khurram saddique" wrote: i have a problem i have made a custom toolbar and some buttons on it then i assign macros to the buttons when i reinstalled office 2003 the custorm toolbar disappeared i have read in form that save the file in xlb format but when i save or export file as personal.xlb there is no option of xlb or how can i export or save as personal.xlb what i do regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
custom toolbar w/ macro | Excel Discussion (Misc queries) | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
Add custom Worksheet and Toolbar in shared drive | Excel Discussion (Misc queries) | |||
Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions |