+ 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
    13

    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
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    845

    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
    13

    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)

Similar Threads

  1. Not allow new worksheets to be added
    By katkth7533 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-10-2015, 12:03 PM
  2. Autofill Summary macro as new worksheets are added
    By rsmiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-12-2014, 04:18 AM
  3. lock row when specific cells have data added.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2013, 05:57 AM
  4. Fix macro to work when worksheets are added
    By messermc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2013, 11:17 AM
  5. Dynamic array in VBA of newly added worksheets
    By greglittle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 06:00 PM
  6. Data that has been added/changed/deleted between two worksheets
    By frank_france in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2012, 05:55 PM
  7. Worksheets not being added
    By msleger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2007, 11:22 AM

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