Thread: Calculating Time Elapsed in Excel
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
(PeteCresswell) (PeteCresswell) is offline
external usenet poster
  
Posts: 139
Default Calculating Time Elapsed in Excel
Per :
One thing that I need now is to lock the column
containing the formula so the user cannot change it .


01) Select all columns via Ctl+A

02) Format|Cells|Protection|Locked=False (you'll have to click the checkbox
twice to make the checkmark go away.

03) Select the column you want protected.

04) Format|Cells|Protection|Locked=True

05) Tools|Protection|Protect Sheet

--
PeteCresswell
Reply With QuoteReply With Quote