Forum Discussion
Solved
Locking Tabs on a shared spreadsheet
Hi, can someone help, I share sheets with around 200 people to add their comments on, the most frustrating thing is when people think they are going to their tab and keep adding blank sheets - is the...
To protect workbook structure, you can try to enable protect structure:
- Open your Excel file.
- Go to the Review tab.
- Click Protect Workbook > Protect Structure.
- Set a password (optional but recommended).
This will prevent users from adding, deleting, renaming, hiding, or moving sheets. Still allow them to edit the content of existing sheets.
-----------------------------------------------------------
If this helped, please mark it as the answer!
To protect workbook structure, you can try to enable protect structure:
- Open your Excel file.
- Go to the Review tab.
- Click Protect Workbook > Protect Structure.
- Set a password (optional but recommended).
This will prevent users from adding, deleting, renaming, hiding, or moving sheets. Still allow them to edit the content of existing sheets.
-----------------------------------------------------------
If this helped, please mark it as the answer!
works a treat thank you.