ExcelBanter - Excel 2000 and filter feature in a protected workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel 2000 and filter feature in a protected workbook (https://www.excelbanter.com/excel-programming/279128-excel-2000-filter-feature-protected-workbook.html)

Mohan[_3_]

Excel 2000 and filter feature in a protected workbook

how to use filter feature in a protected workbook in Excel
2000?

Tom Ogilvy

Excel 2000 and filter feature in a protected workbook

Activesheet.enableAutofilter = True
Activesheet.Protect UserInterfaceOnly:=True

The autofilter already has to be in place with the dropdown arrows showing.

--
Regards,
Tom Ogilvy

"Mohan" wrote in message
...
how to use filter feature in a protected workbook in Excel
2000?

All times are GMT +1. The time now is 07:30 PM.