Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Freeze top row in all MS-Excel worksheets
Message
De
06/01/2014 18:59:06
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Freeze top row in all MS-Excel worksheets
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01591436
Message ID:
01591436
Vues:
56
Hi,

I'm trying to freeze the top row in each worksheet in my workbook.

I'm not quite clear on the use of "Window" in MS-Excel....every other command seems to work on a worksheet or workbook as a whole.

I have tried setting the value to freeze the top row in a worksheet, etc. but the following is the only thing that i have gotten to work when m.tiSheet = 1; the workbook has 10 sheets in it.
WITH m.toWorkbook.WINDOWS[m.tiSheet]
	.SplitColumn = 0
	.SplitRow = 1
	.FreezePanes = .T.
ENDWITH
Can anyone help w/the correct syntax to freeze the top row in EVERY worksheet in the workbook?

TIA, appreciate it!

J
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform