How to make a Spreadsheet as read only?

1 min read

To make Spreadsheet as read only, you need to protect both Workbook and Worksheet using Protect and ProtectSheet method respectively, like below code example.

Spreadsheet.Protect(true, true,"");
Spreadsheet.ProtectSheet(Spreadsheet.ActiveSheet, "");

Sample link:

WPF

WinForms

UWP

Did you find this information helpful?

Yes

Comments (0)

How to make a Spreadsheet as read only?

Access denied