Hi all,

Using this code to make a "Very Hidden" sheet, visible.
It works fine.

Sub ShowSheets()
Dim sPass
sPass = InputBox("Please input password")
If sPass = "12345" Then
Sheet4.Visible = True
End If
End Sub

Goal is when entering password to be able to input a string of random
characters,
of which, the last 5 would be the password. The code will be able to
regonize that
the last 5 characters are correct, ignor all the characters before
that, and run the rest of the code

IE: Someone is looking over my shoulder whom i do not want to know my
password.
I can just enter some jiberish & the last 5 characters being correct.
They will not be able to remember the jiberish they saw me put in.

Does that make sense to anyone?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=528434