Deleted Tools Option from Menu Bar

[Mat K]

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

 

[PowerWheels]

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

 

[Dave Peterson]

Another way:

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

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

 

[Mat K]

Cheers thanks very much, it worked like a charm