Results 1 to 3 of 3

Thread: How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2016
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    Hi,

    I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information.

    How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells?

    thanks

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    24,006
    Post Thanks / Like
    Mentioned
    408 Post(s)
    Tagged
    43 Thread(s)

    Default Re: How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    Select the sheet you want to protect & on the Review tab select "Protect Sheet"
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,221
    Post Thanks / Like
    Mentioned
    35 Post(s)
    Tagged
    8 Thread(s)

    Default Re: How do you protect a sheets or cells or columns in a workbook, instead of the whole workbook?

    You can password protect the few sheets so that a user cannot make entries or change/delete formulas. But, if the user really never needs to see those sheets, it may be easier to make then very hidden. Here's how:
    1. select the sheet.
    2. right-click the sheet's tab (where the sheet name is) and select 'View code'. This will open the VB Editor window (VBE).
    3. Press the F4 key - this opens the sheet's 'Properties' menu on the left side of the VBE.
    4. Scroll down the properties menu to 'Visible' and in the drop down immediately to the right select 2-xlSheetVeryHidden.
    5. save the file and close the VBE.

    Unlike a hidden sheet, a veryHidden sheet cannot be found on the Ribbon menus (such as View>UnHide) which would allow a user to unhide the sheet. If you are concerned that a user might access the VBE/Properties to unhide the sheet, then you can password protect the VBE Project - VBE Menu>Tools>VBAProject Properties>Protection.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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