Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Protect Excel Sheet but allow data filtering
Message
De
03/09/2003 09:16:59
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Protect Excel Sheet but allow data filtering
Divers
Thread ID:
00825638
Message ID:
00825638
Vues:
98
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
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform