View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default filter on a protected sheet

In XL XP (2002) on (I Think), you have the ability to allow filtering in the
worksheet protection dialog

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"peter" wrote in message
ups.com...
I have a sheet on which I need to protect some cells. I have it
filtered. Whenever I protect the sheet, I cannot click on the little
arrow to filter, even on cells that are not protected. What am I doing
wrong?

Thanks,


Peter