Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
khurram saddique
 
Posts: n/a
Default custom toolbar not saved

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   Report Post  
CyberTaz
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying a workbook with custom toolbar assigned to a macro Matt W Excel Discussion (Misc queries) 1 February 4th 05 10:46 PM
custom toolbar w/ macro Darien Excel Discussion (Misc queries) 3 February 2nd 05 09:16 PM
I would like to delete a custom toolbar from the workspace. How? twiga Setting up and Configuration of Excel 1 December 23rd 04 05:55 PM
Add custom Worksheet and Toolbar in shared drive jrcruzr Excel Discussion (Misc queries) 1 December 10th 04 11:06 PM
Deleting custom Commands from File Menu are nor saved next time w. EXCEL CUstomization Excel Worksheet Functions 3 December 7th 04 01:46 AM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"