Cell is locked but still editable...

  • Thread starter Thread starter nogatomer
  • Start date Start date
N

nogatomer

Hi!
i am writing an Excel Addin, that retrives data from server and shows
it on a pre defined template.
i am trying to lock a spesific cell, according to data i retrived from
my server.
before data is entered to sheet, i protect the sheet using:

//i'm protecting the whole sheet
Range tempRange = ws.Cells;
tempRange.Locked = true;
 
Cells are locked to begin with.
You should unlock the cells you want to keep editing and then protect
the sheet.

Like:

Range("E19").Locked = False
ActiveSheet.Protect

Now you can only edit Cell E19

Kaak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2003 & 2007 Differences in Locking Cells Syntax 5
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Modifying a locked/protected sheet 3
Discontiguous Chart Source 4
Sumproduct troubleshooting (new to me) 12
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Protect a worksheet but allow cell editing 3
Locking cells, Excel 2003 SP3 4

Back
Top