Hi. I have a program where I have an inputbox in the 'Workbook event', that prompts me to assign a password to access the file, without going through the tedium of opening the file, going through the disclaimer sheet and various hoops to get to the password area. That part works fine.
Now what I need, is to delete this inputbox as soon as the password is inserted, otherwise anyone will get the inputbox on the "Sign In" sheet, when they open the file...then change the password to whatever.
Here is what I have for the code. Just one line with syntax problem...I think
Thanks so much
Sub Inputbox2() Dim inbx As String inbx = InputBox("Program the New Password" & vbNewLine & vbNewLine & "DEVELOPER SECTION", _ "Assign Password BOX", "Type Here", 1600, 6000) 'This is for the programmer to insert the password for the program Sheets("Default Sheet").Activate Range("B38").Value = inbx If Range("B38").Value = inbx Then 'Something wrong with the syntax in the line below Sheets("Sign In").ibnx.Delete End If End Sub