Deleted Tools Option from Menu Bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mat K - 06 Jan 2006 03:08 GMT

Ok i know this is going to sound stupid but...

I was writting a macro to format a report and wanted to add it to th
tools drop down menu; however whilst i was doing so i stuffed up th
code and instead have deleted the "Tools" option from the command bar
Could someone please let me know how to restore it.

Cheers, Ma

Reply to this Message

PowerWheels - 06 Jan 2006 05:28 GMT

Right click on your toolbar and click customize. Then goto the comman
tab and and find built in menus in the list. You will see the tool
menu to the right, drag it back to the toolbar

Reply to this Message

Dave Peterson - 06 Jan 2006 15:21 GMT

Another way:

View|Toolbars|Customize|toolbars tab
select worksheet menu bar and click Reset

(It'll reset that whole toolbar, though.)

> Ok i know this is going to sound stupid but...
>
[quoted text clipped - 10 lines]
> Mat K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19529
> View this thread: http://www.excelforum.com/showthread.php?threadid=498586

Signature

Dave Peterson

Reply to this Message

Mat K - 08 Jan 2006 21:30 GMT

Cheers thanks very much, it worked like a charm

Signature

Mat K

Reply to this Message