>>>Dear all & especially OLE Automation gurus :-)
>>>
>>>There was an advisor answer in August 2003 issue of VFP Advisor
>>>by Pamela Thalacker on how to protect sheet but alow column formating;
>>>
>>>oXL.ActiveSheet.Protect('Passw', .f. , .t. , .f. , .f. , .t. )
>>>
>>>Problem is that when I try to utilise this call I get an error
>>>
>>>'OLE Error code 0x8002000e: Invalid number od parameters '
>>>
>>>As a matter of fact I want to alow Data filtering feature which is very important to my users.
>>>
>>>In the rest of article full syntax is given with all parameters,
>>>including one I want, but I always get the same message (written above)
>>>
>>>Workable example of how to do this
>>>would be kindly appreciated
>>>
>>>Thks+++
>>>Sergio
>>
>>Are you using the same version of Excel she used? I just tried it using Excel2002 and it worked just fine.
>
>
>No - Excel 2000, maybe feature does not exist in this version.
>
>I would not mind doing it manually because we are talking about two files
>but there is not an option to do it directly in excel - or maybe there is and I just don't know about it ? :-))
>
>Thks for the tip, will try with E2002.
>

I'm pretty sure E2K had protection, but maybe the parameters are different? I don't have it installed so I can try it.