Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How could the sub below be re-expressed the other way around, ie
check the password, then exit sub immediately (with the error msg) if password is incorrect? Sub TestRest() Sheet8.Select Dim ThePassWord As String Dim t As String t = "What's the password" ThePassWord = InputBox(prompt:=t) If UCase(ThePassWord) = "BATTLEFIELD" Then Range("D10").Value = Range("G15").Value Else MsgBox "That is incorrect." End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autoshut Excel if password is incorrect | Excel Discussion (Misc queries) | |||
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
VBA password request upon exit | Excel Programming | |||
VBA Project Password prompt on Exit | Excel Programming | |||
Excel asks for addin password on exit | Excel Programming |