I have a spreadsheet that connects to an internet site.

How can I do a macro to login:

1. Automatically upon opening the sheet
2. Whenever prompted thereafter

Thanks