Youtor
Tutorial Password Protect Macro
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=5wmS8k3IxWU
In this tutorial we outline how you can password protect your macro so that a user must enter the correct password before they can execute the macro in the workbook. • The beginners guide can be located here if you struggled with any of the content. • http://twoperscent.com/index.php/exce... • The written tutorial the accompanies this video can be found at the link below. • http://twoperscent.com/index.php/2017... • The code that we used in this tutorial is as follows. • Private Sub CommandButton1_Click() • Dim password As Variant • password = Application.InputBox( Please Enter Password , Password Protected Macro ) • Select Case password • Case Is = False • 'do nothing • Case Is = password • Sheets( Sheet1 ).Range( A4 ).Select • ActiveCell.EntireRow.Insert shift:=xlDown • Sheets( Sheet1 ).Range( A4:E4 ).Select • Selection.Borders.Weight = xlThin • Case Else • MsgBox The password you entered was incorrect • End Select • End Sub • I hope this has been helpful. For a cleaned up version of the VBA code please visit the written guide.
#############################
