Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Freeze top row in all MS-Excel worksheets
Message
From
06/01/2014 18:59:06
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Freeze top row in all MS-Excel worksheets
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01591436
Message ID:
01591436
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform