Forum Discussion

Chan_Tze_Leong's avatar
Chan_Tze_Leong
Brass Contributor
May 11, 2021
Solved

Excel Macro

I have created 2 Name Managers i.e opex (blue colour) and mtd (green). Using a macro, I would like to unlock these areas (Name manager) and lock the rest (other cells) so that users can key in their ...
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    May 11, 2021

    Chan_Tze_Leong 

    For example:

    Sub UnlockNamedRanges()
    Cells.Locked = True
    Range("opex").Locked = False
    Range("mtd").Locked = False
    ActiveSheet.Protect ' Password:="secret"
End Sub
HansVogelaar's avatar
HansVogelaar
MVP
May 11, 2021

Chan_Tze_Leong 

For example:

Sub UnlockNamedRanges()
    Cells.Locked = True
    Range("opex").Locked = False
    Range("mtd").Locked = False
    ActiveSheet.Protect ' Password:="secret"
End Sub
Chan_Tze_Leong's avatar
Chan_Tze_Leong
Brass Contributor
May 11, 2021
Thanks, Hans. Appreciate the help.