If the "Read-only recommended" box isn't checked when you set up the workbook with a password to open the file, Excel won't prompt with a message. Instead, the workbook simply opens to the last ...

Now, when you go to open the file again, read-only is disabled. This method works in all versions of Microsoft Excel from 2003 through 2016 for all worksheets of this type.