×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to protect some cells in a worksheet

How to protect some cells in a worksheet

How to protect some cells in a worksheet

(OP)
I want to protect some cells of my spreadsheet not the whole worksheet. I want my spreadsheet in a way that, even though it is copied to another sheet, only the values will be pasted not the formula. How can I do that? Thanks!

RE: How to protect some cells in a worksheet

I think it's two separate questions.

To protect part of a spreadsheet:
1 - Use format / cells / protection and check locked or hidden. Make sure the other cells are not protected or hidden.

The protection is not in place yet. First you need...

2 - Tools/Protection/Protect-sheet or Protect-workbook

To allow someone to copy only the results and not the formula, I think you need to allow them to see only the results and not the formula. Put the formula in some part of the workbook which will later be hidden.  In the cell the user will have access to, just add the value of that hidden cell to display it. Then hide that cell so the user can't get to it.  I think this will work.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: How to protect some cells in a worksheet

If you don't want to use the protection options available you can always code a button to copy from another sheet and hide the sheet with the actual formula on it.

RE: How to protect some cells in a worksheet

(OP)
Thanks Electricpete! I protected my worksheet. Aerohap, I'll consider your comment too.  

RE: How to protect some cells in a worksheet

For those formulae you want to protect set the protection to hidden.  Then protect the worksheet.  Now copying the cell will only paste the value of the formula not the formula itself.

To set the hidden property use the format:cells menu item to open the "Format Cells" dialogue.  Then select the protection tab.  To hide formulae ensure that hidden is checked.

HTH

RE: How to protect some cells in a worksheet

If you are worried about someone seing the formula, you could also copy and "paste special / values" over what you have.  Be sure to have saved your file to another name first.

Excel also allows the use of an image of another sheet within a sheet.  This can be used where you want to show cells in a layout that do not match the layout of the sheet.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources