Results 1 to 4 of 4

Thread: Allow only copying of values not formulas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Allow only copying of values not formulas

    Hello,

    Is there a possibility in Excel to allow only copying of values (results) and lock copying of the formulas from the same cell?

    I have an Excel sheet where user has to enter a code in one cell and based on the code he gets results in the other cell - which has to be copied to some other sheet that each user has locally.

    To make it "fault-proof" I have to lock possibility of copying the formulas but allow copying of the values only "automatically".
    Paste Special and choosing only values is not a good solution as there will be a lot of users with very limited Excel knowledge and they have to have just simple copy-paste available otherwise it will be a mess.
    Last edited by Miro H; Sep 16th, 2019 at 04:27 AM.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    227
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Allow only copying of values not formulas

    Miro,

    I'm not sure I understand the issue because if I set my formula cell to Locked and Hidden Format then Protect the sheet I can copy and paste to another sheet but it only copies the result of the formula, which is what I think you want.
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    New Member
    Join Date
    Mar 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Allow only copying of values not formulas

    Hello,

    Yes, that's exactly what I want!

    I set it to Locked but without Hidden Format and everytime formulas have been copied. With hidden I get exactly what I wanted.

    Thanks for help!

  4. #4
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    227
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Allow only copying of values not formulas

    You're welcome!
    Life advice found on a book of matches: "Keep cool. Keep away from children."

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
  •