Spreadsheet cell protection with c#

[texlnghorn]

I am trying to setup my Spreadsheet so that only certain cells are protected.
I can protect my entire active Spreadsheet by specifying:
axSpreadsheet1.ActiveSheet.Protection.Enabled = true;

Is there a way to set up a range of cells to protect? What I really want to
do is protect the first n columns as these correspond to display values only.
I then want to unprotect the remaining columns as these correspond to
editable values. I am using C# to program my OWC Spreadsheet application.

Thanks,
Mike

 

[Alvin Bruney]

the range object contains a protect method that you can use to protect the
selected range

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[texlnghorn]

Alvin,
Thanks for your reply. I'm looking at the Range object but I don't see a
Protect method. There is a Worksheet method that I can protect but it seems
to protect the entire worksheet and not the Range.

-Mike

 

[texlnghorn]

I figured out my problem. I first needed to unlock the range of cells I want
to make editable and then Protect the entire worksheet.

myrange.set_Locked(false);
sp.ActiveWorkSheet.Protection.Enabled = true;

Thanks,
Mike

Alvin,
Thanks for your reply. I'm looking at the Range object but I don't see a
Protect method. There is a Worksheet method that I can protect but it seems
to protect the entire worksheet and not the Range.

-Mike

the range object contains a protect method that you can use to protect the
selected range

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------