Search found 3 matches

by pnconrad
Thu Jul 22, 2010 4:39 pm
Forum: XLSReadWriteII 3/4/5
Topic: Sheet getting protected after saving
Replies: 7
Views: 7895

Re: Sheet getting protected after saving

Solved.
In addition to dragging the component onto the page, one needs to add sheetdata4 to he uses clause.
by pnconrad
Tue Jul 20, 2010 7:27 pm
Forum: XLSReadWriteII 3/4/5
Topic: Sheet getting protected after saving
Replies: 7
Views: 7895

Re: Sheet getting protected after saving

As it was in 2008 it is in 2010.
I have just installed the latest version of XLSReadWriteII v4, and all sheets that I save are protected.
by pnconrad
Tue Jul 20, 2010 5:03 pm
Forum: XLSReadWriteII 3/4/5
Topic: Sheet getting protected after saving
Replies: 7
Views: 7895

Re: Sheet getting protected after saving

I get an undeclared identifier error. when trying to make these changes. xlsfile.Sheets[0].SheetProtection:=[spEditObjects,spEditScenarios, spEditCellFormatting,spEditColumnFormatting,spEditRowFormatting, spInsertColumns,spInsertRows,spInsertHyperlinks,spDeleteColumns, spDeleteRows,spSelectLockedCel...