I need to create an excel sheet out of forms6i. The excel sheet must be protected in a small range. Therefore I create a dummy-excel-file, choose the columns and change the Format-property to unprotect. In forms6i I open the file filled the data in each row, save the file with another name and activate the worksheet-protection with:
OLE2.invoke(worksheet,'Protect');
This protection works. But now the unprotected columns can not be changed in format, setting hyperlinks etc, because in excel you must explizitly choose this properties.
My Question: Are there values for the OLE2.invoke()-method to resolve this problem? I am not able to find the API for OLE2 Automation. Have you any idea, where I can find it.
Thanks.
Eveline Merches
OLE2.invoke(worksheet,'Protect');
This protection works. But now the unprotected columns can not be changed in format, setting hyperlinks etc, because in excel you must explizitly choose this properties.
My Question: Are there values for the OLE2.invoke()-method to resolve this problem? I am not able to find the API for OLE2 Automation. Have you any idea, where I can find it.
Thanks.
Eveline Merches