Is there a way to set a workbook to read-only?

[Chanan Zass]

We're looking for a simple way to turn a workbook to read-only.

Since the workbook includes some 11 sheets, each with a different number of rows and columns we cannot use the spreadsheet range setting (range.set_enabled(false)).

We tried using the workbook.Protected parameter in code-behind, but the "Protected" parameter is somehow not accepted.

Any tips would be appreciated.

[Peter Milchev]

Hello Chanan,

Please check the following KB that describes the same scenario: Load Excel file into a read-only Spreadsheet.

Regards,
Peter Milchev
Progress Telerik

[Chanan Zass]

Thanks again, Peter.

We'll try this and be back to you.

[Chanan Zass]

This works properly with "normal" Excel files (we tested it with a large file).

However, in our case, with our non-standard file, it doesn't. We can still double-click a cell and edit its content.

No big deal, actually, as we do not offer any possibility of saving the file. If required to export, we'll export the original (unedited) file.

Thanks again.