+ Reply to Thread
Results 1 to 2 of 2

Lock & Hide specific cells containing formula with a password

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    28

    Lock & Hide specific cells containing formula with a password

    I've created an excel with lots of macros & formulas.
    Now, I don't want the formulas to be revealed and hide & lock them from the users to see or change.
    At the same time, it must be possible for them to edit other ranges or use certains functionalities.

    Or how do I allow user to only edit specific cells but hide & protect formulas from all the cells?

  2. #2
    Forum Contributor
    Join Date
    03-09-2012
    Location
    Isle of Man
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Lock & Hide specific cells containing formula with a password

    I don't know if I'm being too simplistic or don't get what you are trying to achieve so forgive me if I make myself look silly.

    Make sure worksheet is unprotected.
    Highlight all cells in worksheet and right click - Protection
    Untick locked

    Then select all your cells that you want the formulas hidden on. Right click - protection
    ticked Hidden

    Then protect your worksheet with password. People will still be able to select the cells with formulas in but won't be able to see what the formulas are. if you don't want them to see or select the cells tick locked and hidden when choosing which cells to hide.

+ 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. lock/unlock specific cell in a password protected sheet
    By Opi in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 03-01-2016, 04:43 AM
  2. Inputbox with password to hide/unhide specific sheets in workbook.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 07:41 AM
  3. Replies: 4
    Last Post: 09-23-2013, 01:46 AM
  4. hide and lock cells with formula using vba
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-08-2011, 08:31 PM
  5. Hide specific tabs and password protect
    By dawnmau in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2010, 12:23 PM
  6. lock cells lost password
    By dcutts666 in forum Excel General
    Replies: 2
    Last Post: 04-18-2007, 07:53 AM

Tags for this Thread

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