| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell is locked but still editable...
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; |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell is locked but still editable...
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 -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=528052 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell is locked but still editable...
thank you !
but i am trying to lock it not to unlock it... Tomer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| editable cell in a dropdown list | Excel Worksheet Functions | |||
| locked cell not locked | Excel Discussion (Misc queries) | |||
| How to make cell not editable | Excel Worksheet Functions | |||
| Protect a Cell in an Editable Range | Excel Programming | |||
Hybrid Mode
