Hello all, I need to have this macro stop at the point that ("K7") = "okay" - otherwise it should continue running the rest of the code.
Help is much appreciated as always.
Help is much appreciated as always.
Code:
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:="joker"
If ActiveSheet.Range("K7").Value = "" Then ActiveSheet.Range("K7").Value = "okay"
Range("E3").Select
Dim iComNm As String
Dim iUsrNm As String
iComNm = ReturnComputerName
iUsrNm = ReturnUserName
MsgBox "You are logged in as the following..." & vbNewLine & _
"Computer : " & iComNm & vbNewLine & _
"Username : " & iUsrNm
Sheets("Sheet1").Range("L7").Value = iComNm
Sheets("Sheet1").Range("M7").Value = iUsrNm