Hi Anne and JE,

Thanks for replying. I have a temporary fix, I entered a fictitious
name in the user name box that when the "enter password button" is
clicked it automatically closes the workbook.

If anybody can see an error in my code please let me know what it might
be?

Again, thank you Anne and JE for your help.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=385903