View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Unger Dave Unger is offline
external usenet poster
 
Posts: 153
Default AllowFiltering vs EnableAutoFilter

Hello,

With regard to Autofiltering on a protected sheet, can anyone tell me what the difference (if any) is between these 2 code segments?

ActiveSheet.Protect Contents:=True,Userinterfaceonly:=True,AllowFilter ing:=True

or

ActiveSheet.Protect Contents:=True, Userinterfaceonly:=True
ActiveSheet.EnableAutoFilter = True

I seem to get the same results, using either one. Can't seem to find a definitive answer on any of the forums, etc.

Thank you,

Regards

Dave