Hi Team,
Is there a way to output a password protected xlsx file. I know there a Protected Output macro tool, but I'm unable to download the thrid party tool because of restrictions. Is there a workaround?
Appreciate the help
A macro is essentially smaller tools that have been packaged up, so technically you could replicate the work yourself. If you right click on the macro, you can look at the underlying tools/code.
Another workaround is to us R to python. This link may be helpful:
https://stackoverflow.com/questions/50867641/how-do-i-password-protect-an-excel-file-created-in-r-with-write-xlsx
