+ Reply to Thread
Results 1 to 12 of 12

how can i make my cells formula hidden, but cells can be editable by others.

  1. #1
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    129

    how can i make my cells formula hidden, but cells can be editable by others.

    I use office 2003. i want my cells formulas should remain hidden. but anyone can work on that sheet

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: how can i make my cells formula hidden, but cells can be editable by others.

    select all cells
    then format cells in check everthing
    select cells with formulas in /format cells --hidden
    protect workbook
    http://www.techonthenet.com/excel/ce...e_formulas.php
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    129

    Re: how can i make my cells formula hidden, but cells can be editable by others.

    hi martin,

    but my protect sheet option is showing something else. when i am checking this one, i cant click any of the columns.

    protect.JPG

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: how can i make my cells formula hidden, but cells can be editable by others.


  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Hide formula, but cells can be editable

    Leave the Locked Checkbox as UnChecked and Give Tick in Hidden Checkbox alone and protect the sheet which will give access to you to edit the cell but wont display the formula.

    Caution: There is a chance that you will type some thing in the formula cell since formula's wont be shown and which replace the formula to your newly added value.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  6. #6
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    129

    Re: Hide formula, but cells can be editable

    hi sixth sense,

    the sheet is totally getting non editable after doing that.

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Hide formula, but cells can be editable

    Have you read this text?

    Leave the Locked Checkbox as UnChecked and Give Tick in Hidden Checkbox alone and protect the sheet

  8. #8
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    129

    Re: Hide formula, but cells can be editable

    hi sixth sense,

    sorry for disturbing. yes i did. i am attaching the file here. please tell me if any problem there.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: how can i make my cells formula hidden, but cells can be editable by others.

    ryan,

    I have merged both your threads. Its against forum rule 5 to duplicate threads.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  10. #10
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    129

    Re: how can i make my cells formula hidden, but cells can be editable by others.

    Hi all,

    i am new here. sometimes i cant trace my threads. thats why i have re send again. but slowly i am trying to find it out. i will take care of it in future. many thanks

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,685

    Re: Hide formula, but cells can be editable

    Select the Summary Tab>>Press Ctrl+A twice (To select all cells of that sheet)>>Do right click>>Select Format Cells>>Under Protection Tab>>Click on both Locked and Hidden Check boxes and Uncheck it>>Click OK.

    Select Range R4:S18 (Yellow highlighted cells)>>Do right click>>Select Format Cells>>Under Protection Tab>>Click Hidden Check box ALONE>>Click OK.

    Apply Sheet Protection (Alt+T+P+P)>>Under Allow All User of this worksheet to>>Give Tick Mark in Select Locked Cells & Select unlocked cells>>Give Ok...

    Now Check............

  12. #12
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: how can i make my cells formula hidden, but cells can be editable by others.

    did you watch the video its clearly shown in that

+ 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