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?

Any help would be appreciated.

Alan Harris-Reid