Greetings Excel Forum Team!
Problem Statement: How to make multiple excel columns as non-editable in multiple Tabs using VBA
In the attached spreadsheet (Test-ColumCellNonEditable.xlsm - SEP-Test Tab)
I have column L with specific defined Range(L7 - L22) is made non editable when user clicks on Column L between L7 & L22.
--------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("L7:L22")) Is Nothing Then
Target.Offset(, 1).Select
MsgBox "Executed is Non-Editable"
End If
End Sub
--------------------------------
User Scenario1: Is it possible to make multiple columns with identified ranges such as below as non editable.
Column O Range(O7 - O22),
Column P Range(P7 - P22).
User Scenario2:If I have multiple Tabs like 'SEP-Test', 'AUG-Test' but each Tab need same columns (L,O,P)need to be non editable but range for each Tab varies
Is it possible to have single dynamic function that can handle above need, please let me know.
Appreciate any help with resolution(vba function/proc) for above User Scenario's.
Thank you.
Bookmarks