View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default how to protect cells?

Hi,

Tools, Protection, Protect Worksheet, and add a password or not.

This is after you un-lock cells where you want them to work.

Cheers,
Shane

"angela" wrote:

I have set up a spreadsheet for a co-worker. How do I protect the formulas
so they can't be inadvertently (or intentionally) deleted or written over?
I've tried the instructions "Lock only a few cells on a worksheet" but I can
still change the cells that I want protected.