Thread: lock formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellen ellen is offline
external usenet poster
 
Posts: 32
Default lock formula

Hi,
I want to lock&hide some cells which contain formula, First I select the
cells I want people to access(change valuves) and choose
fromat/cells/protection&untick locked, then choose tools/protection/protect
sheet, add a password, But now the problem is i can not access to any cell
even unlocked ones.(I tried tick or Untick edit objects, failed).
Hope you can help me
Regards
ellen