+ Reply to Thread
Results 1 to 4 of 4

Stop Worksheet being added

  1. #1
    John Calder
    Guest

    Stop Worksheet being added

    Hi

    How can I stop someone from adding worksheets to a workbook?


    Thanks

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,837

    Smile

    Good morning John Calder

    Use Tools > Protection > Protect Workbook. This will do the trick, but you haven't given much information in this post so it may stop you doing other things that you intend to do with the file.

    Also, bear in mind that this security isn't that strong and can be removed fairly easily.

    HTH

    DominicB

  3. #3
    Alan
    Guest

    Re: Stop Worksheet being added

    You can password protect the workbook, however Excel protection is weak and
    easily overcome by anyone with a little knowledge and the will to do so,
    Regards,
    Alan.
    "John Calder" <JohnCalder@discussions.microsoft.com> wrote in message
    news:6E31FF95-D2FE-412A-858B-78CCCB89EBC5@microsoft.com...
    > Hi
    >
    > How can I stop someone from adding worksheets to a workbook?
    >
    >
    > Thanks




  4. #4
    Dave Peterson
    Guest

    Re: Stop Worksheet being added

    Just to add, you'll want to check the structure box in the
    tools|protection|protect workbook dialog.

    This will also stop users from renaming, moving or deleting sheets, too.

    John Calder wrote:
    >
    > Hi
    >
    > How can I stop someone from adding worksheets to a workbook?
    >
    > Thanks


    --

    Dave Peterson

+ 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