Excel automation password protection

I have an excel workbook consisting of 3 sheets. How do i password protect only 1 of the 3 sheets ? ie, users should not be able to view this particular sheet itself unless they have the password.
Thanks in advance


this is not really an automation but an excel question, but check this tutorial: https://business.tutsplus.com/tutorials/how-to-protect-cells-sheets-and-workbooks-in-excel--cms-28736

I don’t know if you can dynamically automate whether or not to provide the password for the specific sheet though.

Cheers, Lukas