View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Woody Woody is offline
external usenet poster
 
Posts: 52
Default Using Filter function with shared workbook



"CFS" wrote:

You should select "Allow Filtering" option in the "Protect Sheet" dialog box.
--
CFS


"Woody" wrote: Thank you very much. It worked perfectly.

I have a shared workbook with protected sheets. I am trying to filter a
column of information. When I click on the arrow in the header it does not
bring up the dialog box for me to choose what to filter on. How can I make
this work?

Woody