| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HasFormula protect cell
Hello wizards,
Below sub works and does not work ...!!! I mean: clicking on a cell that has a formula will "protect" the sheet .... as you can unprotect the sheet. (ToolsProtectionUnprotect) **But** does actually NOT protect at all as I can just overwrite the formula in the cell! Just try and see what I mean... Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.HasFormula = True Then Me.Protect Password:="" Else Me.Unprotect Password:="" End If End Sub Cheers Sige |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect or Unprotect Cell dependent on different cell | Excel Discussion (Misc queries) | |||
| Is it possible to protect cell formatting in an unlocked cell? | Excel Discussion (Misc queries) | |||
| EXCEL: Protect a cell depending on another cell value | Excel Worksheet Functions | |||
| Protect Cell | Excel Worksheet Functions | |||
| protect specific cell but allow edit on other cell | Excel Worksheet Functions | |||
Threaded Mode
