Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to protect an Excel column ???
Message
De
23/02/2007 05:25:21
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
How to protect an Excel column ???
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Divers
Thread ID:
01198231
Message ID:
01198231
Vues:
103
Hello Everybody!

I create an excell sheet with VFP 9.

oleApp = CREATEOBJECT("Excel.Application")
OleApp.Visible=.F.
OleApp.Workbooks.Add
oSheet = oleapp.ActiveSheet

Then i write somme data to rows and columns.

Then i do some formatting
*anpassen
OleApp.columns("A:E").Select
*linksbündig + breite anpassen
With oleapp.Selection
.NumberFormat = "0.00"
.HorizontalAlignment = xlLeft
.Columns.AutoFit
EndWith
*jahr ohne nachkommastellen
OleApp.Range("B1").Select
oleapp.Selection.NumberFormat = "0"

*ende anpassen

Now i want to protect column A:D (readonly ??)
The user can only edit cells in column E.

How to code this from foxpro ???

Any help welcomed

Best regards
Albert

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform