+ Reply to Thread
Results 1 to 3 of 3

Lock Worksheets from being added.

  1. #1
    Registered User
    Join Date
    06-05-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Lock Worksheets from being added.

    Hello

    Please see attached pic. I want to keep from others from inserting additional worksheets.
    How do I go about doing that? Thank you


    exWK.png

  2. #2
    Registered User
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    47

    Re: Lock Worksheets from being added.

    To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.

    On the top ribbon, go to 'Review'. Select 'Protect Workbook' and make sure the 'Structure' is ticked (set a password if required, but be sure not to forget it).
    The little " + " will still show, but the 'structure' of the workbook is protected.

    Trust this helps.

  3. #3
    Registered User
    Join Date
    06-05-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Lock Worksheets from being added.

    Quote Originally Posted by ORoos View Post
    To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.

    On the top ribbon, go to 'Review'. Select 'Protect Workbook' and make sure the 'Structure' is ticked (set a password if required, but be sure not to forget it).
    The little " + " will still show, but the 'structure' of the workbook is protected.

    Trust this helps.
    Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1