Customizing Toolbars

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry Cornil - 24 Mar 2004 12:51 GMT

Several users in our company have been fiddling around with the "Customize toolbars" option and have removed the "View" menu (God knows why). Since they no longer have that menu, they can't restore it..

Up to now, we have been reinstalling Excel

Is there a fast way to reset all the default menus, either with some vba code or a shortcut key

Thanks
Henry Corni
Consultan
InfoLearn (Switzerland)

Reply to this Message

JudithJubilee - 24 Mar 2004 13:10 GMT

Choose Tools + Customize + Toolbars Tab.

Scroll down the list and choose Worksheet Menu Bar and
choose Reset on the left. It will ask you if you want to
reset it to Default, choose Yes

Hope this helps
Judith

>-----Original Message-----
>Several users in our company have been fiddling around with the "Customize toolbars" option and have removed

the "View" menu (God knows why). Since they no longer
have that menu, they can't restore it...

>Up to now, we have been reinstalling Excel.
>
[quoted text clipped - 5 lines]
>InfoLearn (Switzerland)
>.

Reply to this Message

David McRitchie - 25 Mar 2004 17:28 GMT

For those that have customizations that they wish to retain,
a less drastic approach would be to restore the "view" menu.

Tools, Customize, Commands (Tab),
on the left go down to built-in menus", on the right drag "view"
up to the menus area of your toolbar (between Edit and insert).
http://www.mvps.org/dmcritchie/excel/toolbars.htm

You should backup your toolbars, addressbook, favorites, and
other files along with your personal data.
http://www.mvps.org/dmcritchie/excel/backup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Choose Tools + Customize + Toolbars Tab.
>
[quoted text clipped - 18 lines]
> >InfoLearn (Switzerland)
> >.

Reply to this Message