How to disable/restrict the Macro Button?

**Kooper** · 07-20-2012, 02:47 PM

Hi Everyone,

I have spreedsheet and i want to restict the use of Macro button that i created (lock/unlock) to prevent the other cells to be edited as a requirements. (Excel 2010). Is there a way to restrict the Macro button using macro codes?

Sample.PNG

Thanks.

**dangelor** · 07-20-2012, 04:13 PM

Simple, but somewhat effective...

Sub restrictedMacro()
    Const PWord As String = "123abc"
    Dim sPW As String
    
    sPW = InputBox("Enter Password to Continue", "Restricted Action")
    If sPW <> PWord Then Exit Sub
    'Macro follows...
    
    
    
    
End Sub