Excel - XSL protect/password

Does anyone know if during an excel transform via xsl sheet, is it possible to add the protect params and a password?

Thanks
Bill
LVL 11
WilliamAsked:
Who is Participating?
 
jkmyoungCommented:
No.
When you try to save a password protected sheet to xml, excel explicitly forbids it.
If the file is in xml format it cannot be password protected in any way. (range, worksheet, workbook)

I figure the reason is, anybody with a text-editing tool could simply edit out the password protection section.
0
 
Geert BormansInformation ArchitectCommented:
I assume the answer is "no"
The idea behind transformation to XML is to open up the spreadsheet for use in other applications
encrypting only works on the binary excel format
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.