View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Lock formulas from being edited

Is there is any way to protect those formulas from being edited and in
the same keep a personel password for everysheet


No. But you could unlock the cells they need to use and keep it locked
all the time with a password they don't know. That is the typical
method.