Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Protect Excel Sheet but allow data filtering
Message
De
03/09/2003 15:00:06
 
 
À
03/09/2003 09:16:59
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00825638
Message ID:
00825791
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform