View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default protecting formulas

Hi
- select all cells for which you want allow changes
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now goto 'Tools - Protection' and protect your sheet

--
Regards
Frank Kabel
Frankfurt, Germany


Reniek wrote:
I would like to block somehow a part of cells in a sheet. For
example, there is a formula inside and I do not want anybody to
delete it. Do you know some solutions?Thanks