Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to protect a column in a worksheet programmatically ?
Message
From
08/04/2003 17:58:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
How to protect a column in a worksheet programmatically ?
Miscellaneous
Thread ID:
00775265
Message ID:
00775265
Views:
148
Hi All,

This is what I want to do

1. Append data from a dbf table to an empty Excel work sheet
2. Do some formatting on the work sheet. ( Font bold , Calculating etc.)
3. Make the 3rd column (Column C ) Protected/Read only so user can not change any data in this column.

Within my VFP program I was able to open Excel application object and do step 1 and 2. But I’m stuck with the 3rd one. I just don’t know how to make just one column protected after appending the data from dbf table.

Please Help !!!

TIA

- Jeana -
Next
Reply
Map
View

Click here to load this message in the networking platform