Exit Sub if Inputbox cancel, X Button or blank value is used (bypass debug)

a colleague bought it to my attention, i have placed an admin button in the spreadsheet that removes all protections freeing it up for modification to those that have been given the password, however when a NULL value is entered or the cancel or X button is hit, it goes to debug and end users can see the password.

i have the below string however it doesnt quite work, i have always struggled with IFs

Please Login or Register  to view this content.

the 2 x ElseIf is what i have added unfortunately it really doesnt like it.

Many Thanks

Liam

Good afternoon liamtimms1985

Use Application.Inputbox instead :

Please Login or Register  to view this content.

HTH

DominicB

thank you so much..... a pair of legends!