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?

LVL 11
Who is Participating?
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.
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
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.