» Cell protection only for formulas using VBA in Microsoft Excel
CATEGORY - Protecting in VBA
VERSION - All Microsoft Excel Versions
Only cells with formulas are to be protected. New entries are recognized and also protected.
Answer:
Insert the following code in This Workbook module.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
For Each rng In Target.Cells
If rng.HasFormula Then
ActiveSheet.Protect
Exit Sub
Else
ActiveSheet.Unprotect
End If
Next rng
End Sub
Book Store:
Recommended Books:
- Analysis of Financial Statements
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Windows XP for Dummies
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Retire Young, Retire Rich
- Absolute Beginner's Guide to Microsoft Excel 2002
protection of formula
rashid
i am trying to hide formula in cell ,i did check hide and locked.but still i can see formula in formula bar.plz help me out how to protect formula from if i press delete by mistake the formula will be deleted i just want to lock formula cells.
protection
syed atif
how we can protect our only one cell in spreadsheet
