Does the functionality exist to enter a password on protected files or would the file need to be saved without password protection???
No, there was a option to give password for protected excel
You can use Excel Application Scope for that
check below link for more details
Above is for Studio, For StudioX you can check below
Hope this will help you
If you have excel with password you can enter your password in the Excel application scope so that you can access password protected excel file. You can have passwords for your files it would add more security. If you want any other help pls let us know. Thanks.