Hi,
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
Hi,
this is not really an automation but an excel question, but check this tutorial: How to Protect Cells, Sheets, and Workbooks in Excel
I don’t know if you can dynamically automate whether or not to provide the password for the specific sheet though.
Cheers, Lukas