Thread: Excel 2000 and filter feature in a protected workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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?


Reply With QuoteReply With Quote