Missing Autofilter option !!

[anandmr65]

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

 

[papou]

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" <[email protected]> a écrit
dans le message de [email protected]...

 

[Nick Hodge]

Try

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[anandmr65]

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

 

[Nick Hodge]

Anand

Pleasure, thanks for following up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]