EXCEL隐藏自动筛选下拉按钮.docVIP

如何屏蔽/隐藏自动筛选的下拉按钮？ Snap1.jpg 11.85 KB 2009-5-4 15:57 如题：请教高人，有没有办法在excel中自动帅选中时隐藏下拉按钮（切换筛选操作已在VBA代码中实现）？ 附件 2009-5-4 15:58 Range对象的AutoFilter方法中指定参数：VisibleDropdown 下面的代码去掉B列和D列的筛选下拉箭头Sub yanjie Dim rg As Range, i%Application.ScreenUpdating FalseIf Not Sheet1.AutoFilterMode Then Sheet1.[a1].AutoFilteri 0For Each rg In Sheet1.Range A1:D1 i i + 1Select Case iCase 2rg.AutoFilter field: i, visibledropdown: FalseCase 4rg.AutoFilter field: i, visibledropdown: FalseEnd SelectApplication.ScreenUpdating TrueNext rgEnd Sub