ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I enable a disabled Autofilter in Excel (https://www.excelbanter.com/excel-programming/360124-how-do-i-enable-disabled-autofilter-excel.html)

JimFraserPE

How do I enable a disabled Autofilter in Excel
 
I have a spreadsheet with macros and wanted to add another level of
calculations to it. THe Autofilter is disabled and cannot figure out how to
enable it?

Gary''s Student

How do I enable a disabled Autofilter in Excel
 
Depending on your version of Excel you can pull-down:

Help About Microsoft Excel Disabled Items...

and see if Autofilter is disabled.
--
Gary's Student


"JimFraserPE" wrote:

I have a spreadsheet with macros and wanted to add another level of
calculations to it. THe Autofilter is disabled and cannot figure out how to
enable it?


Dave Peterson

How do I enable a disabled Autofilter in Excel
 
Is the worksheet protected?



JimFraserPE wrote:

I have a spreadsheet with macros and wanted to add another level of
calculations to it. THe Autofilter is disabled and cannot figure out how to
enable it?


--

Dave Peterson

Dave Peterson

How do I enable a disabled Autofilter in Excel
 
I think this feature (added in xl2002) works with workbooks/addins. Not
features builtin to excel.



Gary''s Student wrote:

Depending on your version of Excel you can pull-down:

Help About Microsoft Excel Disabled Items...

and see if Autofilter is disabled.
--
Gary's Student

"JimFraserPE" wrote:

I have a spreadsheet with macros and wanted to add another level of
calculations to it. THe Autofilter is disabled and cannot figure out how to
enable it?


--

Dave Peterson


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com