Forum Discussion
SandraKMB
Mar 12, 2020Copper Contributor
Blätter einer Tabelle mit verschiedenen Passwörtern vor Zugriff schützen // One Drive
Hallo - ich möchte eine Tabelle in One Drive speichern und mit mehreren Kollegen teilen. Es gibt ein Tabellenblatt A auf das alle zugreifen können und dort auch Änderungen und Eintragungen vorneh...
Savia
Mar 13, 2020Iron Contributor
You can password protect each sheet by right clicking it and protecting. This will prevent people making changes to that sheet without the password.
If you want to prevent a hidden sheet being unhidden, you can use Review => Protect Workbook => Structure to prevent sheets being hidden or unhidden. However that is a single global setting with one password and can't have different passwords for each sheet.
If you want to prevent a hidden sheet being unhidden, you can use Review => Protect Workbook => Structure to prevent sheets being hidden or unhidden. However that is a single global setting with one password and can't have different passwords for each sheet.