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

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


"Woody" wrote:

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