General information
Category:
COM/DCOM and OLE Automation
Title:
How to protect a column in a worksheet programmatically ?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only