Missing Autofilter option !!

Hi,

I have done a goof up & require your help in undoing the damage

I had opened the View->Toolbars-> Customize option.

While thie customise option was open, I went to Data->Filter->Autofilter option and dragged the "Autofilter" outside the menu.

Now this option is missing from the menu.

Ho wdo I restore the "Autofilter" back?

Please help.

Thanks & REgards
Anand

Hello
Create a new macro in a workbook and place this line:
Application.CommandBars(1).Reset
Run the macro and check your menu.

HTH
Cordially
Pascal

"anandmr65" <anandmr65.29zswz_1151297102.4807@excelforum-nospam.com> a écrit
dans le message de news:
anandmr65.29zswz_1151297102.4807@excelforum-nospam.com...
>
> Hi,
>
> I have done a goof up & require your help in undoing the damage
>
>
> I had opened the View->Toolbars-> Customize option.
>
> While thie customise option was open, I went to
> Data->Filter->Autofilter option and dragged the "Autofilter" outside
> the menu.
>
> Now this option is missing from the menu.
>
> Ho wdo I restore the "Autofilter" back?
>
> Please help.
>
> Thanks & REgards
> Anand
>
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile:
> http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=555453
>

Try

Tools>Customize..>Toolbars tab, select worksheet menu bar and reset...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"anandmr65" <anandmr65.29zswz_1151297102.4807@excelforum-nospam.com> wrote
in message news:anandmr65.29zswz_1151297102.4807@excelforum-nospam.com...
>
> Hi,
>
> I have done a goof up & require your help in undoing the damage
>
>
> I had opened the View->Toolbars-> Customize option.
>
> While thie customise option was open, I went to
> Data->Filter->Autofilter option and dragged the "Autofilter" outside
> the menu.
>
> Now this option is missing from the menu.
>
> Ho wdo I restore the "Autofilter" back?
>
> Please help.
>
> Thanks & REgards
> Anand
>
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile:
> http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=555453
>

Hi,

I tried the "Tools>Customize..>Toolbars tab, select worksheet menu bar and reset..." and it worked.... I am very very happy to see my Autofilter option back in menu .

Thanks to Nick Hodge & Pascal for the guidance in resolving the issue.

Thanks & Regards
Anand

Anand

Pleasure, thanks for following up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"anandmr65" <anandmr65.2a00sc_1151307302.8932@excelforum-nospam.com> wrote
in message news:anandmr65.2a00sc_1151307302.8932@excelforum-nospam.com...
>
> Hi,
>
> I tried the "Tools>Customize..>Toolbars tab, select worksheet menu bar
> and reset..." and it worked.... I am very very happy to see my
> Autofilter option back in menu .
>
> Thanks to Nick Hodge & Pascal for the guidance in resolving the issue.
>
> Thanks & Regards
> Anand
>
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile:
> http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=555453
>