View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default locking formulas

You need to change the properties of the cells you want to be able to enter
data into by going to formatprotectionunlocked then protect the sheet
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"hannatrip" wrote:

I try to lock the cells with the formulas in them, i choose lock from cells
than go to the tools,protect sheet and lock it, now i can put any info at all
on the sheet, what am i doing wrong?? help please