I assume you want to check a users name and password against a list in a .ini file?
I don't think you can once Excel is running. Unless you are writing your own password progie.
A prompt for a password using Excel's native routine invokes an event controlled by Excel.
You can't run a sub or macro while Excel is waiting for the password.
Only one routine can be run at a time.
Otherwise password crackers would have a simple task to defeat Excel.
FYI: sticky notes on the monitor is the most insecure place to keep passwords. An .ini file is the second most insecure.
It's a text file.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.