View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default hide formulas but can edit on the same cells

You can hide the column, but if the sheet is not protected, people could
simply unhide the column to see its contents.
If the information is on a protected worksheet, people will be able to
see it, either by copying and pasting the data to another sheet, or by
using a password cracker to unlock the protected sheet.

Sara wrote:
Hello,

How to I hide and lock the formulas that appear on A1 to A10 let's say,
without locking them? I need to be able to copy and paste the results so I
need to be able to click on them. I also need to share the document, but do
not want people to see the password nor manipulate them.

Thanks.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html