Forum Discussion

Marcous's avatar
Marcous
Copper Contributor
Jan 12, 2022

How to protect worksheet in Excel Web?

Hi,

Could anyone help me with this:

Requirement

  • All Readers of Excel file will open either from Excel Web or Desktop App
  • Owner open/edit from Excel Web
  • Owner wants to hide 1 of the sheet from all Readers except him using password

Issue

  • I have tried hiding it and it work in Excel Desktop App and I can UnHide it but I don't see that option in Excel Web to UnHide and Hide with password.
  • Also, when you UnHide, would that mean it UnHide just for you or will it UnHide for all who have access to this Excel file which is in a OneDrive?

Thanks in advance,

Marcous

  • etoy701's avatar
    etoy701
    Copper Contributor

    Marcous I have the same requirements.  Did you manage to find the solution to this anywhere?

Resources