View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default filter on a protected sheet

But you must have the filters enabled/set prior to protecting the worksheet.

XL 2002 and 2003


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 07:48:23 +0100, "Nick Hodge"
wrote:

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