When you share a protected workbook, only the data is protected, not the workbook structure.

Question

Quizplus · Accepted Answer

When you protect a workbook in Excel, you can choose to protect the workbook structure, which prevents users from adding, moving, deleting, hiding, or renaming worksheets. Sharing a protected workbook does not remove this protection; the workbook structure remains protected unless specifically unlocked by the user with the correct password.

When You Share a Protected Workbook, Only the Data Is