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

--
Mat
-----------------------------------------------------------------------
Mat K's Profile: http://www.excelforum.com/member.php...fo&userid=1952
View this thread: http://www.excelforum.com/showthread.php?threadid=49858

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

--
PowerWheel
-----------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...fo&userid=3004
View this thread: http://www.excelforum.com/showthread.php?threadid=49858

Another way:

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

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

Mat K wrote:
>
> 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 the
> tools drop down menu; however whilst i was doing so i stuffed up the
> code and instead have deleted the "Tools" option from the command bar.
> Could someone please let me know how to restore it.
>
> Cheers, Mat
>
> --
> Mat K
> ------------------------------------------------------------------------
> Mat K's Profile: http://www.excelforum.com/member.php...o&userid=19529
> View this thread: http://www.excelforum.com/showthread...hreadid=498586

--

Dave Peterson

Cheers thanks very much, it worked like a charm


--
Mat K
------------------------------------------------------------------------
Mat K's Profile: http://www.excelforum.com/member.php...o&userid=19529
View this thread: http://www.excelforum.com/showthread...hreadid=498586