My excel toolbar will not keep changes made to it once Excel is closed. As soon as it is reopened, it reverts back to the standard toolbar. I have tried deleting, recreating and changing the .xlb file and have ensured I have given it time to write the changes after closing Excel and then reopening. Any ideas greatly appreciated. Word and PP work fine, just excel is the issue.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Toolbar will not keep changes
- Thread starter Walyeska
- Start date
are you saving your excel file after you have made the changes or are you just closing excel down without saving ?
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Thread starter
- #3
Thanks for the post. I am talking about the xlb (toolbar) file. No matter if I create a new Excel file, change my toolbar, save, exit OR if I just open Excel, change toolbar, save Book1, exit OR if I just open Excel change toolbar and exit. The outcome is always the same. The xlb (toolbar) reverts back to its original settings. If you open Excel delete one of your toolbar Icons, close excel, reopen excel, the toolbar Icon is still gone. On my machine the toolbar always reverts back to its original state. Thanks again!
I know what you are talking about - was just trying to ascertain whether the changes should be implemented or not. If you make a toolbar change and don't save the workbook, it usually doesn't save the change - hence the question. Given that you ARE saving changes, I would suggest that it may be to do with your profile - either the excel installation or user settings
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
I would also recommend attaching toolbars to workbooks as well; there seems to be some [toolbar] performance increase there as well.
I recommend that the best way to keep toolbars/commandbars is to create/delete them programmatically.
-----------
Regards,
Zack Barresse
I recommend that the best way to keep toolbars/commandbars is to create/delete them programmatically.
-----------
Regards,
Zack Barresse
- Status
Similar threads
- Locked
- Question