Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Protect Excel Sheet but allow data filtering
Message
From
03/09/2003 15:00:06
 
 
To
03/09/2003 09:16:59
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00825638
Message ID:
00825791
Views:
16
>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.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform