+ Reply to Thread
Results 1 to 3 of 3

I need full protect my excel formula, i dont want allow copy cut edit my formula

  1. #1
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    I need full protect my excel formula, i dont want allow copy cut edit my formula

    I want fully protect my formula,
    1, i dont want allow to copy my formula,
    2, i want hide my formula in formula bar,
    3, protect formula from others to edit

    i want allow only a2 to a10 cells to edit, all others should be locked,
    note : I already locked other cells, but its allow to copy my formula, and view my formula in formula bar,
    so its waste of time to lock. Any other solution?

    See attached file.
    Password is vv
    Attached Files Attached Files

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: I need full protect my excel formula, i dont want allow copy cut edit my formula

    Highlight your range with your formula>format cell>>protection>tick the hide option. Then protect your sheet again.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: I need full protect my excel formula, i dont want allow copy cut edit my formula

    Than you so much dear buddy....

+ 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. Replies: 3
    Last Post: 02-07-2012, 09:05 AM
  2. Replies: 1
    Last Post: 07-13-2007, 10:59 AM
  3. how to protect & dont show the formula
    By SelinaT in forum Excel General
    Replies: 3
    Last Post: 01-29-2007, 02:23 AM
  4. in excel, formula to work only when all cells full of data
    By DINO in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-24-2005, 03:10 PM
  5. Replies: 2
    Last Post: 09-08-2005, 10:05 PM

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