How/where might one save a USERID & PSWD that is entered via an input box upon the opening of an EXCEL spreadsheet so that one doesn't need to re-enter the same information every time one executes a new macro in that spreadsheet, but making sure that information does disappear when the spreadsheet is saved.
Storing the information in the spreadsheet itself was the first idea, and one can tell a macro to clear that information out upon closing the spreadsheet. The problem is that if one just saves a copy of the spreadsheet rather than closes it, the sensitive information is not cleared out. Saving files containing user/ID and PSWD, however protected or encrypted, violates our company security policy.
Can you make parameters persist somewhere in memory between executions of a macro where that information can be re-accessed by each macro when it is executed, and cleared out when the spreadsheet is saved or closed?