Missing Autofilter option !!
 

Hi,

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

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:confused:


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=555453

Missing Autofilter option !!
 

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" a écrit
dans le message de news:
...

Hi,

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

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:confused:


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=555453

Missing Autofilter option !!
 

Try

ToolsCustomize..Toolbars tab, select worksheet menu bar and reset...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"anandmr65" wrote
in message ...

Hi,

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

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:confused:


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=555453

Missing Autofilter option !!
 

Hi,

I tried the "ToolsCustomize..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

Missing Autofilter option !!
 

Anand

Pleasure, thanks for following up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"anandmr65" wrote
in message ...

Hi,

I tried the "ToolsCustomize..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