Share via

Excel: How can you stop users from adding new tabs?

Anonymous
2021-03-29T01:18:03+00:00

How can you stop users from adding new tabs, but still allow input to existing tabs?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-29T01:58:44+00:00

    Hi HolleyGVS!

    I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

    You can protect your workbook to prevent users from adding new worksheets. Go to Review tab, click Protect Workbook, enter password, verify that "Structure" option is checked by default. Then click OK. Confirm Password dialog pops up. Re-type password and click OK. To check, right click any sheet tab and you can see that the insert option is disabled.

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    8 people found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2021-03-29T07:06:54+00:00

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-03-29T06:34:26+00:00

    HI HolleyGVS

    Jen_L correctly answered your question so for sure that will help 

    I just amended the title of the thread to add more clarity and help others who browse to find the answer as you did. 

    Regards 

    Jeovany

    1 person found this answer helpful.
    0 comments