How to remove individual AutoFilter drop-down lists in Excel for Mac (204061)
The information in this article applies to:
- Microsoft Excel 2004 for Mac
- Microsoft Excel X for Mac
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q204061 SUMMARY
In Microsoft Excel for Mac, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft Visual Basic for Applications.
This article includes a sample Visual Basic macro that hides drop-down
lists in a list to which you applied an AutoFilter.
NOTE: The only way to hide individual drop-down lists in a list to which you applied an AutoFilter is to use the AutoFilter method in a macro; you cannot hide the drop-down list manually.
REFERENCES
For more information about AutoFilter method, from the Visual Basic Editor, click the
Office Assistant, type autofilter, click Search, and
then click to view "autofilter method."
Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
---|
Keywords: | kbcode kbinfo kbProgramming TP_CS KB204061 |
---|
|