microsoft.office.interop.excel and VB.NET. AllowEdit = false not working
Posted on 2008-09-30
I have an excel document that I fill and edit data programatically. I can protect an entire worksheet no problem, but on one sheet I only want to protect one Cell Range so a user can not edit the value, but can still edit the rest of the worksheet. I tried using the range.allowedit but I get an error
" Property 'Allow Edit' is Read Only ' How would I write it in vb.net so I can use that read only property?
Dim cover As Microsoft.Office.Interop.Excel.Worksheet = Doc.Sheets(2)
cover.Range("N3").AllowEdit = False