View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jérémie Gent Jérémie Gent is offline
external usenet poster
 
Posts: 18
Default Protect with AllowFiltering

Following syntax isn't accepted by Excel:
activesheet.protect allowfiltering:=true
(error 1004)

Wasn't it available in Office 2000 ? If it's the problem, then is there
another way to lock the whole sheet while filter remains enabled ?

Thanks!