If I understand your question correctly, you are trying to find a technique where if the user is unable to supply the password for the workbook then they are not offered the option of opening a read only version of the file.
If this is correct, then you are trying to circumvent the way the application - Excel itself - works and it will not be possible to do this using POI IMO. It might be possible to code an add-on to Excel that would emulate this behaviour but you will have to ask for help on this at an Excel forum. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Setting-excel-encryption-problem-tp3319124p3319514.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
