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!
Sounds like this is a navigation issue. Add a Table Of Contents worksheet (make it the first one in the workbook). Then at the top of every sheet add a link back to that ToC worksheet.
To prevent adding worksheets, you can consider protecting the workbook (Review tab).