Alan,
You can use automation to fill the spreadsheet, establish ranges of cells and enable editing of selected ranges once the worksheet protection is turned on. The easiest way to do most automation tasks is to record a macro in Excel, and then copy the VB code from the macro editor and tweak it a bit in your VFP code. VB allows named parameters and VFP can only do positional parameters for method calls.
You can do searches here to find some examples of Excel automation. You might want to look into getting the Granor/Martin book on Office Automation from Hentzenwerke.
>I want to export VFP data to a number of xls-type spreadsheets (using COPY TO... OR EXPORT TO...). When I give these spreadsheets to a number of users to fill-in data via Excel, I don't want all the cells to be editable. Is there any way I can 'lock' (ie. make readonly) columns from within VFP? If so, what about rows and cells also (Or is that pushing my luck)?
>
>If I can't do it from within VFP (my preference), is anyone aware of an external RUN program I can use to adjust .xls column properties automatically (eg. from a batch file) without having to go into every spreadsheet manually via Excel?