Those issues have nothing to do with the code I've provided. Rather, they suggest you need to equip your userform with textboxes for the username & password inputs and do the validation there. A web search should turn up some sample code you could use/adapt.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]